Skip site navigation (1) Skip section navigation (2)

Re: Possible to insert quoted null value into integer field?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Jerry Sievers <jerry(at)jerrysievers(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Possible to insert quoted null value into integer field?
Date: 2004-08-26 02:35:48
Message-ID: 20040826023546.GA31687@svana.org (view raw or flat)
Thread:
Lists: 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(at)svana(dot)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.

In response to

pgsql-general by date

Next:From: Benjamin SmithDate: 2004-08-26 02:43:03
Subject: Constraints to Guarantee unique across tables with foreign key?
Previous:From: Jan WieckDate: 2004-08-26 02:27:15
Subject: Re: Problem to connect to the Windows Port

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group