Re: Violation of NOT NULL - Mailing list pgsql-general

From Fran Fabrizio
Subject Re: Violation of NOT NULL
Date
Msg-id 3CED3215.70308@mmrd.com
Whole thread Raw
In response to Re: Violation of NOT NULL  ("Wm. G. Urquhart" <wgu@wurquhart.co.uk>)
List pgsql-general
>
>
>>With that said if '' does != NULL then what does? Just NULL? In my book
>>NULL means undefined and IMHO you can't get more undefined than ''!
>>
To me, '' is very defined.  You're explicitly telling something to be
set to the empty string.  It has a definite value - "empty string".
 NULL implies that you have no information whatsoever to determine what
the value is.

That's just me. I was always bothered that Oracle did consider empty
strings to be NULLs.  =)

-Fran



pgsql-general by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: pattern search
Next
From: "Joel Burton"
Date:
Subject: Re: Violation of NOT NULL