"Nagib Abi Fadel" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to