Обсуждение: bool and NOT

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

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