Re: Bug #954: select distinct array - Mailing list pgsql-bugs

From Joe Conway
Subject Re: Bug #954: select distinct array
Date
Msg-id 3EA6AEC5.4000805@joeconway.com
Whole thread Raw
In response to Bug #954: select distinct array  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.org wrote:
> test_pg=# SELECT distinct id from array_test ;
> ERROR:  Unable to identify an ordering operator '<' for type 'integer[]'
>         Use an explicit ordering operator or modify the query
> test_pg=#

There is no bug here. As the error says, there is currently no ordering
operator for arrays. There is a *possibility* that it will change in
7.4. But it hasn't happened yet, and time is running short, so don't
count on it.

Joe

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: UNION Types Mismatch
Next
From: "Riaan van Jaarsveld"
Date:
Subject: PostgreSQL 7.3 Installation Error