Re: Optimizing query: select ... where id = 4 and md5(...) = '...'

Hi Alban,

On 7/3/06, Alban Hertroys <alban(at)magproductions(dot)nl> wrote:
> Alexander Farber wrote:
> > punbb=> select username, md5('deadbeef' || password) from users where id
> > = 4;
> > username | md5
> > ----------+----------------------------------
> > Vasja | dcde745cc304742e26d62e683a9ecb0a
> > (1 row)
>
> Why don't you store the hashed value instead?

actually it's not me - it's the punBB forum SW
( http://docs.punbb.org/dev.html#dbtables )
against which I want my libpq-program to authenticate.

And additional reason is that I could change my salt string
if I wanted and the users could still authenticate without
changing their passwords

Regards
Alex

--
http://preferans.de