select distinct point?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: select distinct point?
Date: 2003-01-04 01:15:41
Message-ID: 87n0mhr9z6.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


You can't select distinct on the point datatype column? I see why it's
nonobvious how to sort points but then how come it works fine to select
distinct on a box column?

slo=> create table test (p point);
CREATE TABLE
slo=> select distinct * from test;
ERROR: Unable to identify an ordering operator '<' for type 'point'
Use an explicit ordering operator or modify the query
slo=> create table test2 (b box);
CREATE TABLE
slo=> select distinct * from test2;
b
---
(0 rows)

--
greg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2003-01-04 01:41:56 Re: example table functions?
Previous Message Tom Lane 2003-01-04 01:04:13 Re: boolean over char(1)