Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot declare record members NOT NULL - Mailing list pgsql-general

From Cultural Sublimation
Subject Re: Cannot declare record members NOT NULL
Date
Msg-id 457056.83020.qm@web63403.mail.re1.yahoo.com
Whole thread Raw
In response to Re: Cannot declare record members NOT NULL  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Cannot declare record members NOT NULL  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
Hi,

> I presume you mean that the server is saying the column can be NULL,
> not that it is actually NULL, since:

Yeah, that is the correct semantics: "it can be NULL".  It does make
a world of difference on the client side, because an "int4 never NULL"
is a different type from "int4 possibly NULL".  The type mismatch
means the program won't even compile.

Cheers,
C.S.



      ____________________________________________________________________________________
Shape Yahoo! in your own image.  Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: Partial index with regexp not working
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: an other provokative question??