Re: IN clause

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Ragnar <gnari(at)hive(dot)is>
Cc: surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in, pgsql-general(at)postgresql(dot)org
Subject: Re: IN clause
Date: 2006-11-24 21:06:52
Message-ID: 662619.87484.qm@web31806.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> yes, except I think you meant:
> (unknown or false or false) = unknown
>
> as can be demonstrated by:
>
> test=# \pset null 'null'
> Null display is "null".
> test=# select (null or true);
> ?column?
> ----------
> t
> (1 row)
>
> test=# select (null or false);
> ?column?
> ----------
> null
> (1 row)

Thanks for the clearification. I was totally wrong on that point. :-)

Regards,

Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2006-11-24 21:09:01 Re: PGDATA
Previous Message ben short 2006-11-24 20:56:41 Connecting via ssh tunnel