[SQL] md5 in pg_shadow?

Hi, I was trying to write a function to validate the username and its password in the pg_shadow table. The function should take in the username and password as arguments and see if it matches with those in the pg_shadow table. But the md5 hashed password in pg_shadow doesnot match with what i get w

Re: [SQL] md5 in pg_shadow?

On Thu, May 12, 2005 at 03:01:17PM -0600, [EMAIL PROTECTED] wrote: > > I was trying to write a function to validate the username and its password in > the pg_shadow table. The function should take in the username and password as > arguments and see if it matches with those in the pg_shadow table. B

Re: [SQL] interesting SQL puzzle - concatenating column with itself.

Nick Fankhauser <[EMAIL PROTECTED]> writes: > Alvaro Herrera wrote: > > > The order is not really guaranteed, though if this is a one-shot thing, > > you may get away with turning off hashed aggregates. > > > > When I read this, I assumed there was a runtime parameter I could set that was > sim