boolean query

From: "Ben-Nes Yonatan" <nimrod(at)canaan(dot)co(dot)il>
To: <pgsql-general(at)postgresql(dot)org>
Cc: <da(at)canaan(dot)co(dot)il>
Subject: boolean query
Date: 2001-09-28 11:23:26
Message-ID: 00a301c1480f$fe0786e0$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 Daniel M . Kurry 2001-09-28 11:41:38 Re: UNIQUE constraint and indexing
Previous Message Dinesh Parikh 2001-09-28 10:49:53 Fw: Problem Related to Goto