Postgres Pro
Downloads
Home   >   mailing lists

Re: NOT NULL Issue - Mailing list pgsql-general

From Tom Lane
Subject Re: NOT NULL Issue
Date
Msg-id 13230.1189824708@sss.pgh.pa.us
Whole thread Raw
In response to NOT NULL Issue  ("Gustav Lindenberg" <gustav.lindenberg@gmail.com>)
Responses Re: NOT NULL Issue  (Geoffrey Myers <geof@serioustechnology.com>)
List pgsql-general
Tree view 
"Gustav Lindenberg" <gustav.lindenberg@gmail.com> writes:
> Why is ''  not considered null is postgres (8.1.3)

Because they're different.  The SQL spec says that an empty string
is different from NULL, and so does every database in the world except
Oracle.  Oracle, however, does not define the standard.

            regards, tom lane

pgsql-general by date:

Previous
From: Felipe de Jesús Molina Bravo
Date:
Subject: %tsearch2-affix parse error dictionary spanish
Next
From: rihad
Date:
Subject: getting min/max of two values