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 = '
Ok, casting to ::text solves the problem, but still I think we
need to fix it in the right way
Oleg
On Sat, 4 Dec 2010, Oleg Bartunov wrote:
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
On 03.12.2010 23:53, Oleg Bartunov wrote:
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 '
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
On 03.12.2010 23:53, Oleg Bartunov wrote:
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
What does it means ?
GROUP BY requires b-tree