Re: Couple of question on functions - Mailing list pgsql-general

From Vyacheslav Kalinin
Subject Re: Couple of question on functions
Date
Msg-id 9b1af80e0805132100r42faf185w4e6501d30a9df8e8@mail.gmail.com
Whole thread Raw
In response to Re: Couple of question on functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> You might think it's "likely", but in fact no inlining will happen
> because you have a volatile argument that's used more than once inside
> the function body.  Inlining would change the results.

Yeah, right, apparently I overestimated chances of inilining, thanks for the hint, Tom. In fact in my project performance problem was caused by the fact that the analogue of f2sql() was declared SECURITY INVOKER and thus could not be inlined :-/. Uhm, does anyone else think inlining tips are worth mentioning in docs or it's just me?

pgsql-general by date:

Previous
From: Stefan Schwarzer
Date:
Subject: Re: Substring Problem
Next
From: Gerald Quimpo
Date:
Subject: Re: Affected # of Rows After TRIGGER/RULE Return