Re: hiding normalization with views

From: Giles Lean <giles(at)nemeton(dot)com(dot)au>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: Re: hiding normalization with views
Date: 2002-10-08 21:30:39
Message-ID: 12294.1034112639@nemeton.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Ray 2002-10-08 21:34:01 What causes a table's oid to change?
Previous Message Josh Berkus 2002-10-08 20:26:01 Re: Setting up PAM authentication