Quick Links

Re: NOT NULL Issue

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	"Gustav Lindenberg" <gustav(dot)lindenberg(at)gmail(dot)com>
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	Re: NOT NULL Issue
Date:	2007-09-15 02:51:48
Message-ID:	13230.1189824708@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

"Gustav Lindenberg" <gustav(dot)lindenberg(at)gmail(dot)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

In response to

NOT NULL Issue at 2007-09-10 18:36:01 from Gustav Lindenberg

Responses

Re: NOT NULL Issue at 2007-09-15 11:24:26 from Geoffrey Myers

Browse pgsql-general by date

	From	Date	Subject
Next Message	rihad	2007-09-15 07:40:50	getting min/max of two values
Previous Message	Felipe de Jesús Molina Bravo	2007-09-14 21:27:20	%tsearch2-affix parse error dictionary spanish