Delete query
| От | Sandeep Joshi |
|---|---|
| Тема | Delete query |
| Дата | |
| Msg-id | 3A5CC36A.973E9973@zambeel.com обсуждение |
| Ответ на | RE: backend corruption ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>) |
| Список | 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 по дате отправления: