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.
