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