Hi,
I have noticed a rather odd behaviour that is not strictly a bug, but is
unexpected.
It is when a immutable (or stable) PG function is returning results in a
record structure a select on these calls the function repeatedly for each
element in the output record.
See below for an example.
Sur
nsible example where LATERAL will *not* do
the trick, so the oddity becomes academic.
So just a thing to remember: *always use lateral with functions with record
result types* - unless they are volatile)
Med venlig hilsen
*Eske Rahn*
Seniorkonsulent
+45 93 87 96 30
e...@septima.dk
--
