| From: | Sandeep Joshi <sjoshi(at)Zambeel(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Delete query |
| Date: | 2001-01-10 20:17:46 |
| Message-ID: | 3A5CC36A.973E9973@zambeel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nelio Alves Pereira Filho | 2001-01-10 20:28:54 | Transaction Log |
| Previous Message | Stephan Szabo | 2001-01-10 18:17:24 | Re: The type conversion CAST does not work ?? |