Re: [GENERAL] how to sort an array and remove duplicate in plpgsql

2007-02-26 Thread Chris Coleman
OTECTED] On Behalf Of David Gagnon Sent: 26 February 2007 14:16 To: pgsql-general@postgresql.org Subject: [GENERAL] how to sort an array and remove duplicate in plpgsql Hi all, I'm messing up with this problem for a while and I searched the web without success. I have an array of timest

Re: [GENERAL] how to sort an array and remove duplicate in plpgsql

2007-02-26 Thread A. Kretschmer
am Mon, dem 26.02.2007, um 9:15:52 -0500 mailte David Gagnon folgendes: > Hi all, > > I?m messing up with this problem for a while and I searched the web without > success. I have an array of timestamp and I needed sorted and I need to > remove > duplicate value. The Select statement offers

[GENERAL] how to sort an array and remove duplicate in plpgsql

2007-02-26 Thread David Gagnon
Hi all, I'm messing up with this problem for a while and I searched the web without success. I have an array of timestamp and I needed sorted and I need to remove duplicate value. The Select statement offers the SORT BY and UNIQUE that may help me but so far I didn't find the way to plug my ar