Postgres Pro
Downloads
Home   >   mailing lists

bool and NOT - Mailing list pgsql-general

From Sascha Ziemann
Subject bool and NOT
Date
Msg-id 7u1z2xojd8.fsf@olivia.aibon.ping.de
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Columns in pg_shadow?
Next
From: Mike Mascari
Date:
Subject: Re: bool and NOT