Re: sort a referenced list - Mailing list pgsql-general

From Matthew Peter
Subject Re: sort a referenced list
Date
Msg-id 20060404071000.5103.qmail@web35207.mail.mud.yahoo.com
Whole thread Raw
In response to Re: pl/pgsql uniq varchar[] sort?  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: sort a referenced list  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'll help clarify exactly what I am trying to accomplish.

What I'm trying to do is create a function that accepts a list then sorts and groups the values (like in sql)... I will have an unique list I can convert it to an array later or leave it a list

I'd like to keep it simple and manipulate the argument like...

select $1 as list
group by list
order by list asc;

Which doesn't work, but that is the functionality I need if possible.


New Yahoo! Messenger with Voice. Call regular phones from your PC for low, low rates.

pgsql-general by date:

Previous
From: Leon Pu
Date:
Subject: Re: Database restoration performance issue on PostgreSQL 7.4.7
Next
From: "patrick"
Date:
Subject: recover from base directory?