2010/8/29 Tom Lane <[email protected]>: > Pavel Stehule <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
