pgcryto strangeness...

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pgcryto strangeness...
Date: 2002-01-05 08:46:40
Message-ID: 20020105004640.S36993@ninja1.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Just started using the pgcrypt 0.4.2 (very cool stuff) and am having
some strange errors (not so cool). Can someone make sense of the SQL
below? I'm not 100% sure what's going on or not going on...

host=# SELECT DIGEST('asdf', 'md5') FROM users_shadow;
digest
------------------------------------------------
\221.\310\003\262\316I\344\245A\006\215IZ\265p
(1 row)

host=# SELECT DIGEST(password, 'md5') FROM users_shadow;
ERROR: Function 'digest(varchar, unknown)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
host=# SELECT DIGEST(CAST(password AS bytea), CAST('md5' AS TEXT)) FROM users_shadow;
ERROR: Cannot cast type 'varchar' to 'bytea'

Any ideas as to how I can do this? -sc

--
Sean Chittenden

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mlw 2002-01-05 13:12:42 Re: Some interesting results from tweaking spinlocks
Previous Message Brent Verner 2002-01-05 07:54:33 Re: Some interesting results from tweaking spinlocks

Browse pgsql-patches by date

  From Date Subject
Next Message Bear Giles 2002-01-05 15:46:38 Re: pgcryto strangeness...
Previous Message Bruce Momjian 2002-01-05 02:28:32 Re: Undocumented feature costs a lot of performance in COPY