I think what he was looking for was more along the lines of a generic sql
function that hashes a string, and not to update the system tables.
I actually wrote a replacement for the mysql PASSWORD() function that is
actually compatible with the hashing that mysql uses. If you would like a
copy of
Is there any easy way to find out the number of rows updated by a update
or insert statement in pl/pgsql? I searched the mailing list archives and
didn't come up with anything. Oh and BTW doing an insert/update combined
with select following won't exactly work as it is possible for this table
to