hello, i have a database in postgresql that have a column boolean, then when i create a query in ejb like this(SELECT e.letsaythisisboolean FROM sample e), now problem is that when i query the database in ejb, it will return all the false value in the column boolean, and the true value will not return... How can i make the true value appear in my query result? Any suggestion or help... thanks, dychalres -- View this message in context: http://www.nabble.com/Qeury-a-boolean-column-%28using-postgresql---EJB%29-tf4808294.html#a13757431 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
