ERROR: could not identify an equality operator for type box

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема ERROR: could not identify an equality operator for type box
Дата
Msg-id Pine.LNX.4.64.1012040051500.12632@sn.sai.msu.ru
обсуждение исходный текст
Ответы Re: ERROR: could not identify an equality operator for type box  (Oleg Bartunov <oleg@sai.msu.su>)
Re: ERROR: could not identify an equality operator for type box  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
Hi there,

create table qq (b box);
CREATE TABLE
select count(*), b from qq group by b;
ERROR:  could not identify an equality operator for type box
LINE 1: select count(*), b from qq group by b;

but following select works fine
 select ' (43.6038,48.8664536),(1.3620777,1.44327)'::box = ' (43.6038,48.8664536),(1.3620777,1.44327)'::box; ?column? 
---------- t
(1 row)                        ^
What does it means ?
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Patch to add a primary key using an existing index
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: GiST insert algorithm rewrite