Skip site navigation (1) Skip section navigation (2)

Re: feature request ?

From: sad <sad(at)bankir(dot)ru>
To: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>,pgsql-sql(at)postgresql(dot)org
Subject: Re: feature request ?
Date: 2004-06-25 06:20:41
Message-ID: 200406251020.41387.sad@bankir.ru (view raw or flat)
Thread:
Lists: pgsql-sql
On Friday 25 June 2004 09:37, Rosser Schwarz wrote:
> On Fri, 25 Jun 2004 08:16:47 +0400, sad <sad(at)bankir(dot)ru> wrote:
> > > Very simply, a boolean may have to values: true or false.  It's also
> > > possible that it's not been set to anything (NULL).
> >
> > really ?
> > what about   (13 < NULL)::BOOL
>
> Per the semantics of NULL, 13 is neither greater than nor less than
> NULL.  NULL is the *unknown* value; it's impossible to meaningfully
> compare it to anything else. Try (NULL = NULL)::boolean. It's NULL,
> also.

READ THE THREAD BEFORE ANSWER


In response to

Responses

pgsql-sql by date

Next:From: Jan Norman PedersenDate: 2004-06-25 07:16:58
Subject: Re: rules
Previous:From: Achilleus MantziosDate: 2004-06-25 06:08:13
Subject: tsearch2,pgsql 7.4.[1|2], pg_dump problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group