Re: Optimizing query: select ... where id = 4 and md5(...) = '...' - Mailing list pgsql-general

From Alexander Farber
Subject Re: Optimizing query: select ... where id = 4 and md5(...) = '...'
Date
Msg-id 943abd910607031214y58d623abrd65738ab2b4b24a@mail.gmail.com
Whole thread Raw
In response to Re: Optimizing query: select ... where id = 4 and md5(...)  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
Hi Alban,

On 7/3/06, Alban Hertroys <alban@magproductions.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

pgsql-general by date:

Previous
From: "Joko Siswanto"
Date:
Subject: Automatic Installer
Next
From: "Alejandro Michelin Salomon \( Adinet \)"
Date:
Subject: RES: php can't connect to postgresql server