Yes
On Thu, 2005-01-13 at 10:12, Doug McNaught wrote:
> Dave Smith <[EMAIL PROTECTED]> writes:
>
> > I am trying to add a unique constraint on a column that can be null. The
> > documentation states that null is treated as non equal values but I want
> > them to be equal. Is there another way of d
On Thu, Jan 13, 2005 at 09:01:08 -0500,
Dave Smith <[EMAIL PROTECTED]> wrote:
> I am trying to add a unique constraint on a column that can be null. The
> documentation states that null is treated as non equal values but I want
> them to be equal. Is there another way of doing this other than wri
-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 <[EMAIL PROTECTED]> writes:
On Thu, 200
On Thu, 2005-01-13 at 11:02, Doug McNaught wrote:
> Dave Smith <[EMAIL PROTECTED]> 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 creat
Dave Smith <[EMAIL PROTECTED]> 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.
-Doug
---(end of broadcast)---
TIP 2: you can g
Dave Smith <[EMAIL PROTECTED]> writes:
> I am trying to add a unique constraint on a column that can be null. The
> documentation states that null is treated as non equal values but I want
> them to be equal. Is there another way of doing this other than writing
> a before insert trigger?
UNIQUE
I am trying to add a unique constraint on a column that can be null. The
documentation states that null is treated as non equal values but I want
them to be equal. Is there another way of doing this other than writing
a before insert trigger?
--
Dave Smith
CANdata Systems Ltd
416-493-9020
-
