Re: 0/1 vs true/false

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 <franco(at)akyasociados(dot)com(dot)ar> 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
>