Re: Possible to insert quoted null value into integer field? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Possible to insert quoted null value into integer field?
Date
Msg-id 20040826023546.GA31687@svana.org
Whole thread Raw
In response to Re: Possible to insert quoted null value into integer field?  (Jerry Sievers <jerry@jerrysievers.com>)
List pgsql-general
On Tue, Aug 24, 2004 at 08:23:14AM -0400, Jerry Sievers wrote:
> As I recall, there is a comment in the release notes somewhere between
> your PG version and the current one, that int cols no longer take
> empty string as NULL.

IIRC, an empty string was interpreted as a zero, never as a NULL.
It is now (rightfully) rejected...
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Problem to connect to the Windows Port
Next
From: Benjamin Smith
Date:
Subject: Constraints to Guarantee unique across tables with foreign key?