Re: Bug #954: select distinct array

From: Joe Conway <mail(at)joeconway(dot)com>
To: bhuvansql(at)myrealbox(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #954: select distinct array
Date: 2003-04-23 15:18:29
Message-ID: 3EA6AEC5.4000805@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-04-24 02:31:30 Re: PostgreSQL 7.3 Installation Error
Previous Message Tom Lane 2003-04-23 14:15:20 Re: UNION Types Mismatch