[ogsa-dai-users] Boolean columns in PostgreSQL and DAI/DQP

[Jose-Luis A. <am...@is...>]

Hi,

I need to do a selection on a Boolean column of a PostgresSQL database 
accessed using DAI/DQP.

If I query PostgressSQL directly,any of the following work:

select * from mytable where mybooleancolumn='t' ;
select * from mytable where mybooleancolumn='1' ;
select * from mytable where mybooleancolumn=TRUE ;

Unfortunately, in DAI/DQP the queries with the quotes fail. The only 
query that (I could find that) work is:

select *
from MyPSQLResource_mytable
where mybooleancolumn=TRUE ;

Having to use the constant TRUE in our program causes some problems for us.

Is there any other way in DAI/DQP to define a selection on a Boolean 
column in a SQL query?

Thanks,


Jose Luis

-- 
Jose Luis Ambite, Ph.D.
USC Information Sciences Institute
4676 Admiralty Way, Marina del Rey, CA 90292, USA
Tel: +1-310-448-8472, Fax: +1-310-822-0751
http://www.isi.edu/~ambite