Hi,
A question on IMMUTABLE functions: do they only have to return the same value
during a session/connection or during the databse server's lifetime? The
documentation does not say anything about that.
I wrote a function that uses the CURRENT_USER session variable, and for my
current usage it is very important, that it returns a different value for
each database connection.
The current implementation is session, but it is quite important that this
behaviour will be the same in future releases. If it must be the same during
server lifetime, I had to rewrite the function to have the CURRENT_USER
variable passed as parameter (that would not be a big issue, of course).
Thanks for your attention,
Daniel Schreiber
--
Daniel Schreiber | ICQ: 220903493
GPG encrypted Mail welcome! Key ID: 25A6B489
Chemnitzer Linux-Tag:
http://www.tu-chemnitz.de/linux/tag/