Delete query

Sandeep Joshi <sjoshi@zambeel.com>

From: Sandeep Joshi <sjoshi@Zambeel.com>
To: pgsql-general@postgresql.org
Date: 2001-01-10T20:17:46Z
Lists: pgsql-general
>

What is wrong with following queries?

Query1:
delete from zuser where userid = 1 and user_setid = 1;

ERROR:   ERROR:  Unable to identify an operator '&&' for types 'int4' and
'int4'
        You will have to retype this query using an explicit cast

Query2:
delete from zuser where userid = '1'::int4 and user_setid = '1'::int4;

ERROR:   ERROR:  Unable to identify an operator '&&' for types 'int4' and
'int4'
        You will have to retype this query using an explicit cast

Query3:
delete from zuser where userid = '1'::integer and user_setid =
'1'::integer;

ERROR:   ERROR:  Unable to identify an operator '&&' for types 'int4' and
'int4'
        You will have to retype this query using an explicit cast


thanks,
sandeep