Delete query - Mailing list pgsql-general

From Sandeep Joshi
Subject Delete query
Date
Msg-id 3A5CC36A.973E9973@zambeel.com
Whole thread Raw
In response to RE: backend corruption  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List 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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: The type conversion CAST does not work ??
Next
From: Nelio Alves Pereira Filho
Date:
Subject: Transaction Log