Thread: bool and NOT

bool and NOT

From

Sascha Ziemann

Date:

20 May 2000, 05:55:49

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

Re: bool and NOT

From

Mike Mascari

Date:

20 May 2000, 06:07:52

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