MySQL PASSWORD('x') function workalike

In MySQL, I can get a hash of a VARCHAR by using the PASSWORD('') call. I
know for DB admin there is pg_passwd, but is there a function interface so
that I can get password hashes of arbitrary strings in SQL?  (Note that I
mean crypto hashes like MD5 and hopefully compatible with the hashes used
for pg_passwd).

Thanks,
Nate