"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