Re: AW: functions returning records

>
>> For the result from foo() you must somewhere define attributes
>> (names).
>> Where? In CREATE FUNCTION statement? Possible must be:
>>
>> select name1, name2 from foo() where name1 > 10;
>
> Yes, optimal would imho also be if the foo() somehow had access to the
> where restriction, so it could only produce output, that the
> higher level is interested in, very cool. This would be extremely
> useful for me. Very hard to implement, or even find an appropriate
> interface for though.

You could easily implement it *in* the function foo IMHO. Since the
function does some black magic to create the result set to begin with, you
can change it to use parameters:

select name1, name2 from foo(10, NULL, NULL) where name1 > 10;