Re: Delete query

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

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: Transaction Log
Следующее
От: "Martin A. Marques"
Дата:
Сообщение: Re: drop table and references