Format of BOOLEAN
От
Lehmeier, Michael
Тема
Format of BOOLEAN
Дата
Msg-id
2BC8FB121C58D4118D5100D0B72016BA8394@tznks01.ct.de
Список
Дерево обсуждения
Format of BOOLEAN "Lehmeier, Michael" <michael.lehmeier@cognitech.de>
Re: Format of BOOLEAN "Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>
Re: Format of BOOLEAN Peter Eisentraut <peter_e@gmx.net>
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 VALUES (true); INSERT 161246 1 testdb=# SELECT * FROM testtable; acolumn --------- t (1 row) testdb=# SELECT * FROM testtable WHERE acolumn = t; ERROR: Attribute 't' not found This is a real problem for me since I am currently writing on a mostly database independent engine. PostgreSQL would be the the first time that I can't write into a database what I read from it. Is it possible to change the settings of PostgreSQL somewhere so that I get 'true' or 'false'? Thank you!
В списке pgsql-general по дате отправления
От: reinoud@xs4all.nl (Reinoud van Leeuwen)
Дата: