Re: Delete query - Mailing list pgsql-general

From Sandeep Joshi
Subject Re: Delete query
Date
Msg-id 3A5CD696.736FE695@zambeel.com
Whole thread Raw
In response to RE: backend corruption  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-general
Sorry, my mistake.


Sandeep


> >
>
> 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: "Mikheev, Vadim"
Date:
Subject: RE: Transaction Log
Next
From: "Martin A. Marques"
Date:
Subject: Re: drop table and references