|
On 17/10/2013 00:06, Merlin Moncure
wrote:
That being said, I do think it might be better behavior (and still technically correct per the documentation) if volatile query expressions were force-evaluated. This sounds reasonable for a "yes or no" case like this, but wouldn't it raise the question of how many times the function should be evaluated? What if the query looked more like this: with tt_created as ( select fn_new_item(foo) as item from some_huge_table ) select item from tt_created limit 10 Should the CTE be calculated in its entirety, running the function for every row in some_huge_table? Or should it run at most 10 times? Which is desired would depend on the situation, but there's no real way to indicate in the syntax. -- Rowan Collins [IMSoP] |
