Re: [SQL] password encryption

2000-07-24 Thread Aaron Sethman
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

[SQL] Finding number of updated rows in pl/pgsql

2000-06-05 Thread Aaron Sethman
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