| From: | Mª José Sempere <mjose(at)pixelart(dot)es> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | digest as IMMUTABLE function |
| Date: | 2004-12-10 12:33:44 |
| Message-ID: | 000001c4deb4$7fa9f1e0$0900a8c0@mj |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
We were trying to create an index using the digest function like that (where
picture is a bytea field):
create unique index my_index on my_table digest(picture, 'md5'));
but we got the error:
ERROR: functions in index expression must be marked IMMUTABLE
So, we have created the function digestinmutable(), like that:
CREATE OR REPLACE FUNCTION digestinmutable(bytea, text)
RETURNS bytea AS
'$libdir/pgcrypto', 'pg_digest'
LANGUAGE 'c' IMMUTABLE;
And after that, we have created the index using the new function
(digestinmutable) :
create unique index my_index on my_table digestinmutable(picture, 'md5'));
IT SEEMS TO WORK OK. Does Anybody know if we'll have any problem using md5
in that way?
Thank you very much for your help.
Bye
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hemapriya | 2004-12-10 16:51:28 | vacuum analyze takes long time |
| Previous Message | Mª José Sempere | 2004-12-10 10:04:49 | pgcrypto module for WINDOWS |