Skip site navigation (1) Skip section navigation (2)

Re: openoffice and boolean

From: tony <tony(at)tgds(dot)net>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: openoffice and boolean
Date: 2004-12-28 18:12:18
Message-ID: 1104257538.3777.12.camel@hush (view raw or flat)
Thread:
Lists: pgsql-jdbc
Le mardi 28 décembre 2004 à 11:52 -0600, Scott Marlowe a écrit :

> > 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

returns "was expecting - or NULL"

> or simply
> 
> select * from sometable where somefield

I'll try and write that into the non standard SQL editor of OpenOffice. 

Thanks

Tony


In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-12-28 20:23:04
Subject: Re: Open connections
Previous:From: Scott MarloweDate: 2004-12-28 17:52:36
Subject: Re: openoffice and boolean

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group