On 11/11/11 15:54, Julius Tuskenis wrote:
On 2011.11.11 17:38, Sorin Dudui wrote:
I have the following function:
CREATE OR REPLACE FUNCTION xxx(text)
[snip]
LANGUAGE sql STABLE
Function execute plan is prepared when creating it, so the "where"
clause should check the function result not altering its execution..
Not true for SQL functions. They can be inlined, but I'm not sure if
this one will be.
What does EXPLAIN ANALYSE show for this query?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
