Re: Adding UNIQUE constraint on NULL column - Mailing list pgsql-general

From Frank D. Engel, Jr.
Subject Re: Adding UNIQUE constraint on NULL column
Date
Msg-id A13B51F0-65AB-11D9-8A04-0050E410655F@fjrhome.net
Whole thread Raw
In response to Re: Adding UNIQUE constraint on NULL column  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Or look at:

http://archives.postgresql.org/pgsql-sql/2003-08/msg00286.php

(and possibly its follow-up)

On Jan 13, 2005, at 3:16 PM, Scott Marlowe wrote:

> On Thu, 2005-01-13 at 11:02, Doug McNaught wrote:
>> Dave Smith <dave.smith@candata.com> writes:
>>
>>> On Thu, 2005-01-13 at 10:12, Doug McNaught wrote:
>>
>>>> Are you really saying that you want 'NULL = NULL' to return 't'?
>>
>>> Yes
>>
>> Well, that's not how NULL works.
>
> In this instance, just create an artificial NULL, like a text string of
> "NONE" and insert that.
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>
>
- -----------------------------------------------------------
Frank D. Engel, Jr.  <fde101@fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFB5uqc7aqtWrR9cZoRAmrYAJ9xn7/4BJSDIkV2HKa0LuTaH3dkawCfXwe+
LOlaK7dCVRjsx+InLCaxkwA=
=paot
-----END PGP SIGNATURE-----



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com


pgsql-general by date:

Previous
From: John Cunningham
Date:
Subject: Re: pgpool
Next
From: Tom Lane
Date:
Subject: Re: Cursor bug?