Re: Should we consider empty fields as NULL values when - Mailing list pgsql-general

"Nagib Abi Fadel" <nagib.abi-fadel@usj.edu.lb> writes:

>    The issue is that since the column col1 is defined as character with
>    not null attribute,
>
>    shouldn't we deny such inserts (i mean inserting empty fields)???

NULL and the empty string '' are *completely* different things.  If
you want to disallow empty strings as well as NULL, use a CHECK
constraint on that column.

-Doug