Re: openoffice and boolean - Mailing list pgsql-jdbc

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