> >> 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; Yes, but this is only an answer to a limited scope of the problem at hand, and the user who types the select (or uses a warehouse tool) needs substantial additional knowledge on how to efficiently construct such a query. In my setup the function would be hidden by a view. Andreas ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
