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 testt

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=# S

[GENERAL] Format of BOOLEAN

2001-06-12 Thread Lehmeier, Michael
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 (acolumn BOOLEAN); CREATE testdb=# INSERT INTO testtable VA