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 по дате отправления: