RE: boolean isn't boolean? - Mailing list pgsql-general

From Marc Britten
Subject RE: boolean isn't boolean?
Date
Msg-id ABFF67479EC9D111AFA30060B01AACDA03ADF6A7@mail
Whole thread Raw
In response to boolean isn't boolean?  (Marc Britten <mbritten@cybernet-usa.com>)
Responses RE: boolean isn't boolean?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
normaly i wouldn't be this picky but......

language-lawyer version.. you used the wrong version of the lang, the docs
say it complies to SQL3, which has completely different wording than SQL99

-----Original Message-----
From: Peter Eisentraut [mailto:peter_e@gmx.net]
Sent: Thursday, June 22, 2000 11:17 AM
To: Marc Britten
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] boolean isn't boolean?


Marc Britten writes:

> why does a boolean value return a t or an f?

The language-lawyer version:

ISO/IEC 9075-5:1999 ("SQL99") 17.2 GR6

"If [the result of the query expression] is not empty, then [it] is
returned. The method of returning [it] is implementation-defined."

Then that's how this implementation defines it. :-)


pgsql-general by date:

Previous
From: Vassili A Akimov
Date:
Subject: Need to improve performance
Next
From:
Date:
Subject: Re: PostgreSQL General Digest V1 #266