Re: hiding normalization with views - Mailing list pgsql-novice

Ron Johnson wrote:
> Since there are only 50 states, plus territories and Canada,
> changing [bill|alt]_state to CHAR(2) is a good idea.

... only a good idea if you know the customer base is North America
only.  Outside the USA, CHAR(2) is a dubious choice.  Probably doesn't
matter in this instance. :-)

Giles