[GENERAL] Sorting array field

[Pete Deffendol]

Hi,

Can anyone point me toward an SQL function (whether built-in or an
add-on) that will allow me to sort the contents of an array datatype in
an SQL query?

Something like this:

select sort(my_array_field) from my_table;

Thanks!

Pete

[GENERAL] Drop user doesn't drop granted privs?

[Pete Deffendol]

Correct me if I'm wrong, but it seems that PostgreSQL 7.4 does not remove a user's privileges on tables when that user is dropped.  The privileges are still showing up if I do a \z in psql, but with the SYSID instead of the username (obviously, since the username doesn't exist.)  Is there an easy way to remove the privileges, either at the same time a user is dropped, or afterwards?
Pete