RE: [GENERAL] Format of BOOLEAN

2001-06-12 Thread Nicolas Huillard
-Message d'origine- De: Lehmeier, Michael [SMTP:[EMAIL PROTECTED]] 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';

Re: [GENERAL] Format of BOOLEAN

2001-06-12 Thread Thalis A. Kalfigopoulos
On Thu, 7 Jun 2001, Lehmeier, Michael wrote: Hello When I SELECT a row with a BOOLEAN in it I get either 't' or 'f'. But when I use this same value in the WHERE condition I get an error, because PostgreSQL demands either 'true' or 'false'. Example: testdb=# create table testtable