RE: Format of BOOLEAN - Mailing list pgsql-general

From Nicolas Huillard
Subject RE: Format of BOOLEAN
Date
Msg-id 01C0F37A.7B08AE20.nhuillard@ghs.fr
Whole thread Raw
In response to Format of BOOLEAN  ("Lehmeier, Michael" <michael.lehmeier@cognitech.de>)
List pgsql-general
> -----Message d'origine-----
> De:    Lehmeier, Michael [SMTP:michael.lehmeier@cognitech.de]
> Date:    jeudi 7 juin 2001 18:06
> Objet:    [GENERAL] Format of BOOLEAN
>
> testdb=# SELECT * FROM testtable WHERE acolumn = t;
> ERROR:  Attribute 't' not found

testdb=# SELECT * FROM testtable WHERE acolumn = 't';

Don't forget the single quote around the t : a boolean is a single char...

NH

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Slow DROPing Table
Next
From: Limin Liu
Date:
Subject: Re: Big5 contains '\'