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
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 |
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 |