-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';
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