Re: select distinct and order by - Mailing list pgsql-general

From Stephan Szabo
Subject Re: select distinct and order by
Date
Msg-id Pine.BSF.4.21.0108152248060.77073-100000@megazone23.bigpanda.com
Whole thread Raw
In response to select distinct and order by  (newsreader@mediaone.net)
Responses Re: select distinct and order by  (newsreader@mediaone.net)
List pgsql-general
On Thu, 16 Aug 2001 newsreader@mediaone.net wrote:

> Pg complained that select distinct column and
> order by column must be the same.

Depending on what you are doing, you may be able to
use group by with an explicit set value function on
the sort by field (for example:
select foo from table group by foo order by min(bar);)

(I don't know anything about the dbi interface really, so i'll
leave that part for someone who does)



pgsql-general by date:

Previous
From: newsreader@mediaone.net
Date:
Subject: select distinct and order by
Next
From: "Dr. Evil"
Date:
Subject: Storing images in PG?