Stephan Szabo wrote:
On Wed, 7 May 2008, Matthew T. O'Connor wrote:
But I would really like to be able to combine it with other data and get
a result set that looked like:
f.id, f.name, tms_summary.col1, tms_summary.col2 ...
Well I think
select f.id, f.name, (tms.get_tms_summary(f.id)).* from foo f;
would expand it out into separate columns, but I think that might also
call it multiple times. You might have better luck combining that with a
subquery like
select id, name, (summary).col1, (summary).col2, ... from
(select id, name, tms.get_tms_summary(f.id) as summary from foo) f;
Ah, I knew there was an easy way to do it, I totally forgot / missed /
didn't know about the (composite type).* syntax.
Thank you!
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
