On Apr 20, 2009, at 2:27 PM, Eric B. Ridge wrote:

Some investigation showed that the use of non-IMMUTABLE PL/PGSQL functions as view columns, when these views are joined with other views, cause the query to be planned poorly.

I'm sorry. I should have said VOLATILE functions. Which is the default if nothing is specified (and that's true for 8.1 and 8.4)

eric

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to