Assumptions when validating user data (Re: [Techtalk] SQL learning pointers)

[Alvin Goats]

> You cannot _require_ the state in Australia (requiring the postal code
> is fine), since there are postal codes that do not correspond to any
> state (certain government and military ones, for example). A similar
> situation exists in the USA, I believe (some zip codes have no state).
> 


Actually, all zipcodes have a state or territory, but may not have any
other address (street, number or city). Our Internal Revenue Service
mail goes to a city, state and zipcode, no other address. A few really
large companies have their own zipcode and don't list a street address
either.

Alvin