bool and NOT

From: Sascha Ziemann <szi(at)aibon(dot)ping(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: bool and NOT
Date: 2000-05-20 05:56:03
Message-ID: 7u1z2xojd8.fsf@olivia.aibon.ping.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jurgen Defurne 2000-05-20 05:56:34 Re: Auto-uppercase inserted column
Previous Message Tom Lane 2000-05-20 05:30:08 Re: Performance (was: The New Slashdot Setup (includes MySql server))