Re: pgcryto strangeness...

Sean Chittenden wrote:

> Yeah, it does... but it also tells me I'm SOL for 7.1.3 even though
> pgcrypto comes with a DECODE() function (only supports 'hex' and
> 'base64'). Any other ideas? <:~) -sc
>

Not sure if you are in a position to do this, but why not make your
password field bytea instead of varchar? This won't work if you need to
support multibyte passwords, but I think it should be fine otherwise.

test=# create table users_shadow_2(password bytea);
CREATE
test=# insert into users_shadow_2 values('secret');
INSERT 1492553 1
test=# SELECT DIGEST(password, 'md5') FROM users_shadow_2;
digest
------------------------------------------------------
^\276"\224\354\320\340\360\216\253v\220\322\246\356i

Joe