At 01:12 AM 9/10/2006 +0330, Behrang Saeedzadeh wrote:
Hi,
Shouldn't this create statement trigger an error?
create table bar (col1 int not null default null);
No.
Shouldn't I be forbidden to insert null values into a non null column?
Yes.
Use "not null default null" when you want to force apps/people etc to
explicitly specify values when inserting.
Link.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
