On Saturday 06 January 2001 17:56, Tom Lane wrote:
> "Robert B. Easter" <[EMAIL PROTECTED]> writes:
> > The IS operator is supposed to return only TRUE or FALSE, never NULL.
> > See ISO/IEC 9075-2:1999 6.30
>
> Yeah, we do not implement IS TRUE, IS FALSE, etc per spec. IS [NOT] NULL
> is the o
"Robert B. Easter" <[EMAIL PROTECTED]> writes:
> The IS operator is supposed to return only TRUE or FALSE, never NULL. See
> ISO/IEC 9075-2:1999 6.30
Yeah, we do not implement IS TRUE, IS FALSE, etc per spec. IS [NOT] NULL
is the only one of the group that works per-spec; the others all
er
CREATE TABLE nulltest (nullfield);
INSERT INTO nulltest VALUES (null);
pgcvs=# select (nullfield = 'willbenull') is null from nulltest;
?column?
--
t
(1 row)
pgcvs=# select (nullfield = 'willbenull') is true from nulltest;
?column?
--
(1 row)
pgcvs=# select (nullfield = 'w
