Thread: Qeury a boolean column?(using postgresql & EJB)
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.
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
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.
[Please don't top post as it makes the discussion more difficult to follow.] On Nov 17, 2007, at 10:24 , dycharles wrote: > 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... I strongly suspect you're not showing us the entire query you're using because this should work. If you want to figure out what's wrong, please provide a self-contained example which displays the behavior you're seeing. Michael Glaesemann grzm seespotcode net