AW: functions returning records - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: functions returning records
Date
Msg-id 11C1E6749A55D411A9670001FA68796336834C@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: functions returning records  ("Reinoud van Leeuwen" <reinoud@xs4all.nl>)
List pgsql-hackers
>  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.

Andreas


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Non-trivial rewriting sql query
Next
From: "Reinoud van Leeuwen"
Date:
Subject: Re: AW: functions returning records