Jeff Amiel <[EMAIL PROTECTED]> writes:
> What is the difference between:
> select foo();
> and
> select * from foo();
They're implemented differently, partly for legacy or lack-of-round-tuit
reasons, and partly because different PLs prefer different strategies
for returning sets.
The first form o
What is the difference between:
select foo();
and
select * from foo();
Foo is defined as:
CREATE OR REPLACE FUNCTION foo()
RETURNS SETOF integer AS
'SELECT column from foo_table;'
LANGUAGE 'sql' STABLE;
Explain shows difference...
explain select * from foo()
"Function Scan on foo (cos
What is the difference between:
select foo();
and
select * from foo();
Foo is defined as:
CREATE OR REPLACE FUNCTION foo()
RETURNS SETOF integer AS
'SELECT column from foo_table;'
LANGUAGE 'sql' STABLE;
Explain shows difference...
explain select * from foo()
"Function Scan on foo (cos
