Re: [SQL] Joining with result of a plpgsql function

2008-05-07 Thread Matthew T. O'Connor
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

Re: [SQL] Joining with result of a plpgsql function

2008-05-07 Thread Stephan Szabo
On Wed, 7 May 2008, Matthew T. O'Connor wrote: > I have a pl/pgsql function, defined as: > > CREATE FUNCTION tms.get_tms_summary(id integer) >RETURNS tms.tms_summary > > get_tms_summary returns a composite type, tms_summary, which is > comprised of several numerics. > > What I would like to d

[SQL] Joining with result of a plpgsql function

2008-05-07 Thread Matthew T. O'Connor
Hello, I have a pl/pgsql function, defined as: CREATE FUNCTION tms.get_tms_summary(id integer) RETURNS tms.tms_summary get_tms_summary returns a composite type, tms_summary, which is comprised of several numerics. What I would like to do is something like: select f.id, f.name, tms.get_tms