"William Harazim" <wharazim(at)fulcoinc(dot)com> writes:
> Ahh, the password || username format of the stored password was the problem. Incidentally, for anyone else not having the md5() function (is that new to 7.5dev?) I was able to accomplish the same thing using
> 'md5' || encode( digest(password || username, 'md5'), 'hex' )
md5() is in 7.4, but I think it's new in that release.
regards, tom lane