Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Bence SzaboDate: 2001-09-28 10:28:44
Subject: TEST DATA GENERATION
Previous:From: nmiletDate: 2001-09-28 10:24:25
Subject: Re: PgSQL behind a firewall

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group