[HACKERS] STABLE functions

2005-02-01 Thread strk
Hello all, I saw that STABLE-defined functions don't get replaced by their output, shoudn't they ? Following shows that VOLATILE and STABLE functions outputs won't get into the Filter, while IMMUTABLE will. Documentation says that STABLE is the modifier to use for functions which don't change

Re: [HACKERS] STABLE functions

2005-02-01 Thread Tom Lane
strk [EMAIL PROTECTED] writes: Hello all, I saw that STABLE-defined functions don't get replaced by their output, shoudn't they ? Following shows that VOLATILE and STABLE functions outputs won't get into the Filter, while IMMUTABLE will. The examples are acting exactly as they should. See

Re: [HACKERS] Stable functions problem

2004-12-20 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: I'm having a bounce of errors because IMMUTABLE and STABLE attributes for some of my functions. Let me explain with an example, Hmm. This particular example is a bug in exec_eval_simple_expr() ... if we're going to bypass SPI then we'd

[HACKERS] Stable functions problem

2004-12-19 Thread Gaetano Mendola
Hi all, after several weeks away I downloaded today the 8.0rc1 and I tested it with our application. I'm having a bounce of errors because IMMUTABLE and STABLE attributes for some of my functions. Let me explain with an example, what I do is ( plpgsql ) my_id_user = sp_id_user( a_login ); IF

Re: [HACKERS] Stable functions problem

2004-12-19 Thread Tom Lane
Gaetano Mendola [EMAIL PROTECTED] writes: I'm having a bounce of errors because IMMUTABLE and STABLE attributes for some of my functions. Let me explain with an example, Hmm. This particular example is a bug in exec_eval_simple_expr() ... if we're going to bypass SPI then we'd better do the