Re: [GENERAL] 0/1 vs true/false

[Franco Bruno Borghesi]

and what about boolean attirbutes in where clauses? Is any difference between

-SELECT ... WHERE boolean_field
and
-SELECT ... WHERE boolean_field=true
?

On Wed, 2003-07-23 at 11:48, Tom Lane wrote:

Franco Bruno Borghesi <[EMAIL PROTECTED]> writes:
> This makes me wonder, what about 't' and 'f'?... will they disappear in
> newer versions of postgreSQL?

No.  See my comment about I/O representations being outside the spec.
There is no inconsistency in the following examples:

regression=# select true;
 bool
------
 t
(1 row)

regression=# select t;
ERROR:  attribute "t" not found
regression=# select 't'::boolean;
 bool
------
 t
(1 row)

regression=# select '1'::boolean;
 bool
------
 t
(1 row)


			regards, tom lane

signature.asc
Description: This is a digitally signed message part