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 по дате отправления
От: Matteo Centenaro
Дата:
Сообщение: problem with Pl/Pgsql function
От: reinoud@xs4all.nl (Reinoud van Leeuwen)
Дата:
FAQ