thank for the reply, i already do that method, but nothing happen... i have another solution to that one, i just used 1 and 0 for true and false.. it sounds bad, but thats the only thing i can do to maximized my time.... thanks... regards, dycharles Michael Glaesemann-2 wrote: > > > On Nov 14, 2007, at 17:05 , dycharles wrote: > >> 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... > > If you want *only* rows which have e.letsaythisisboolean as true, then: > > select e.letsaythisisboolean > from sample e > where e.letsaythisisboolean; > > Your query is returning all of the rows of the table. Either sample > doesn't contain any rows where letsaythisisboolean is true or you > just haven't looked through all of them yet. > > Michael Glaesemann > grzm seespotcode net > > > > ---------------------------(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 > > -- View this message in context: http://www.nabble.com/Qeury-a-boolean-column-%28using-postgresql---EJB%29-tf4808294.html#a13810116 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
