Re: bool and NOT

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Sascha Ziemann <szi(at)aibon(dot)ping(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: bool and NOT
Date: 2000-05-20 07:06:08
Message-ID: 39263960.C842C0E6@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sascha Ziemann wrote:
>
> Hi,
>
> how should I write this:
>
> todolist=# select name from tasks_t where id = 5 and NOT done;
> ERROR: argument to NOT is type 'numeric', not 'bool'
>
> bis später...
> Sascha

SELECT name FROM tasks_t WHERE id = 5 AND done = False;

Hope that helps,

Mike Mascari

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Urlichs 2000-05-20 08:09:00 Re: Performance (was: The New Slashdot Setup (includes MySql server))
Previous Message Tom Lane 2000-05-20 06:01:22 Re: Columns in pg_shadow?