Re: unique constraint - bug? - Mailing list pgsql-general

From Philip Warner
Subject Re: unique constraint - bug?
Date
Msg-id 3.0.5.32.20000721011054.025824e0@mail.rhyme.com.au
Whole thread Raw
In response to Re: unique constraint - bug?  (mikeo <mikeo@spectrumtelecorp.com>)
Responses Re: unique constraint - bug?  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-general
At 10:56 20/07/00 -0400, mikeo wrote:
>in oracle 8.1.6:
>
>i'd say that it finds 1,null,3 equal the 2nd time around...
>

   Ditto for Dec/Rdb.
   Ditto for SQL/Server 7.

They both also object to null values in the primary key, FWIW: SQL/Server
won't let a field be part of a PK unless it is set 'Not Null', and Dec/Rdb
causes a constraint failure when a NULL value is inserted.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/

pgsql-general by date:

Previous
From: "Alex Bolenok"
Date:
Subject: Re: Re: Migrating from MS SQL server
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] 8Ko limitation