contrib/pgcrypto functions not IMMUTABLE?
Michael Fuhr <mike@fuhr.org>
From: Michael Fuhr <mike@fuhr.org>
To: pgsql-hackers@postgresql.org
Date: 2005-07-03T05:32:36Z
Lists: pgsql-hackers
I've noticed that contrib/pgcrypto/pgcrypto.sql.in doesn't include a volatility category in its CREATE FUNCTION statements, so the functions are all created VOLATILE. Shouldn't most of them be IMMUTABLE? Or do the algorithms have side effects? So far I've found no discussion about this except for one person asking about it last year: http://archives.postgresql.org/pgsql-admin/2004-12/msg00065.php -- Michael Fuhr http://www.fuhr.org/~mfuhr/