Lehmeier, Michael writes:
> testdb=# SELECT * FROM testtable WHERE acolumn = t;
> ERROR: Attribute 't' not found
SELECT * FROM testtable WHERE acolumn = 't';
Or better yet (SQL compatible):
SELECT * FROM testtable WHERE acolumn is true;
The latter is a special syntax, whereas in the former the 't' is just an
ordinary data literal.
> Is it possible to change the settings of PostgreSQL somewhere so that
> I get 'true' or 'false'?
case when acolumn then 'true' else 'false' end
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
