Re: [GENERAL] NULL vs. Empty String

2001-03-14 Thread David Wheeler
On Wed, 14 Mar 2001, Oliver Elphick wrote: > You could write a rule for each table/column that would substitute > NULL for ''. > > However, the concept is all wrong. NULL means "I don't know what > this value is". '' means "I know that this value is an empty string". > Furthermore, having NULLs

Re: [GENERAL] NULL vs. Empty String

2001-03-14 Thread Oliver Elphick
David Wheeler wrote: >Is there a way to get Posgres to assume that a '' insert should be a NULL >insert? And if not, does anyone know of a way to get mod_perl to make that >assumption instead? You could write a rule for each table/column that would substitute NULL for ''. However, the conc