- Архив списков рассылки pgsql-general

hi

i need to select rows from a table and to store them into an array.
and next, i would like to sort my array depending on some criteria.

so, my questions are :
how to store rows into a array ?
and how reverse some lines ?
(example : row[i]=row[i+1])

thanks in advance

        Will