On Tue, 2004-12-28 at 11:14, tony wrote:
> Hello,
>
> Connecting OOo 1.1.2 to Postgresql via JDBC I can't seem to find the
> correct OOo query editor criteria for a boolean value. Does anyone know
> the magic formula? The value in the database is 't'. = TRUE ='t' etc.
> etc. don't work.
Those queries are usually of the format:
select * from sometable where somefield IS TRUE
or simply
select * from sometable where somefield