boolean query

From: "Ben-Nes Yonatan" <nimrod(at)canaan(dot)co(dot)il>
To: <pgsql-general(at)postgresql(dot)org>
Subject: boolean query
Date: 2001-09-28 10:24:42
Message-ID: 003901c14807$c96b2de0$ab5796d4@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Bence Szabo 2001-09-28 10:28:44 TEST DATA GENERATION
Previous Message nmilet 2001-09-28 10:24:25 Re: PgSQL behind a firewall