"Craig A. James" <cjames@xxxxxxxxxxxxxxxx> writes: > select count(1) from (select foo_init(value) from foo_init_table order by value_id) as foo; > And indeed, it count() returns 800, as expected. But my function foo_init() never gets called! Really? With the ORDER BY in there, it does get called, in my experiments. What PG version is this exactly? However, the short answer to your question is that PG does not guarantee to evaluate parts of the query not needed to determine the result. You could do something like select count(x) from (select foo_init(value) as x from foo_init_table order by value_id) as foo; to ensure that foo_init() must be evaluated. regards, tom lane
