ERROR: could not identify an equality operator for type box - Mailing list pgsql-hackers

From Oleg Bartunov
Subject ERROR: could not identify an equality operator for type box
Date
Msg-id Pine.LNX.4.64.1012040051500.12632@sn.sai.msu.ru
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Patch to add a primary key using an existing index
Next
From: Heikki Linnakangas
Date:
Subject: Re: GiST insert algorithm rewrite