"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