boolean query - Mailing list pgsql-general

From Ben-Nes Yonatan
Subject boolean query
Date
Msg-id 00a301c1480f$fe0786e0$ab5796d4@canaan.co.il
Whole thread Raw
List pgsql-general
Haloa!
i got a boolean column (named 'seen') which contain the values '1' and '0' (depends on the item)
now.. when i query the DB with the string "SELECT * FROM categories WHERE seen='1';"
it brings me all of the items including those which seen='0'
doesnt anyone know y?
with thx in advance
Ben-Nes Yonatan
 

pgsql-general by date:

Previous
From: "Steve Wolfe"
Date:
Subject: FYI (Fw: [CLA-2001:427] Conectiva Linux Security Announcement - mod_auth_pgsql)
Next
From: Arcady Genkin
Date:
Subject: Re: Authenticating user `postgres'