Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Boolean data types

1 view
Skip to first unread message

pavunkumar

unread,
Mar 5, 2009, 6:46:10 AM3/5/09
to pavu...@gmail.com
Dear Friend

can any one explain about this scenario
I have table called like below

Column | Type | Modifiers
--------+---------+-----------
a | boolean |
b | text |


I inserted some value into the table

I want true value tuple means
pavunkumar=> SELECT * from boll where a ;
a | b
---+-------
t | pavun
t | pavun
t | pavun
t | pavun
t | pavun
(5 rows)

I want to select which contain false value

How could I do that one ?

Timothy Madden

unread,
Apr 19, 2009, 4:21:16 PM4/19/09
to

How about
SELECT * FROM boll WHERE NOT a;
?

Timothy Madden

0 new messages