Re: possible wierd boolean bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: possible wierd boolean bug?
Date
Msg-id 8115.1103144613@sss.pgh.pa.us
Whole thread Raw
In response to Re: possible wierd boolean bug?  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-hackers
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> Anyways, it would be nice to be able to use the sql row constructor to
> do equality/comparison...wouldn't get caught writing such silly sql
> statements :)

You mean like this?

regression=# select row(1,2,3) = row(1,2,3);?column?
----------t
(1 row)

regression=# select row(1,2,3) = row(1,2,4);?column?
----------f
(1 row)

The semantics aren't right yet for non-equality comparisons, but it
works fine for = and != ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: possible wierd boolean bug?
Next
From: Andrew Dunstan
Date:
Subject: race condition for drop schema cascade?