Re: Delete query

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