On Oct 8, 2004, at 10:19 PM, David Garamond wrote:

Michael Glaesemann wrote:
In any case, one would never use NULL. Either the domain includes a value for all possible values (including N/A) or you set up the db schema appropriately.

Hm, that can be painful. What if I have ten optional attributes; separate them to ten different tables?

Strictly? That's how I understand it. Whether or not it's performant under PostgreSQLis another matter. :)


Michael Glaesemann
grzm myrealbox com


---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to