2010/8/29 Tom Lane <t...@sss.pgh.pa.us>: > Pavel Stehule <pavel.steh...@gmail.com> writes: >> I testing a simple use case and I was surprised with very slow >> execution of SQL functions > > The one case is inline-able and the other not (because it would result > in double evaluation of the volatile function random()). > See EXPLAIN VERBOSE.
I understand now. So it means general advice - don't use a boolean operators in SQL function? This issue should be documented somewhere? Regards Pavel Stehule > > regards, tom lane > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
