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/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
