From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org, fduch(at)antar(dot)bryansk(dot)ru |
Subject: | Re: Problem with looping on a table function result |
Date: | 2003-08-04 09:26:08 |
Message-ID: | 3F2E26AF.627C4763@rodos.fzk.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
>
> I've met the following problem.
> I had successfully written a function divide_into_days(timestamp,
timestamp)
> which returns setof (timestamp, timestamp) pairs - a list of days the
> given interval is divided into.
>
> What I want is to use each record from resultset to pass to another
> function, something like:
>
> SELECT days.*, summary_stats(days.day_start, days.day_end)
> FROM divide_into_days('2003-06-01', '2003-07-01') days;
>
> The problem is that summary_stats function returns a record, so I have
> to use SELECT * FROM summary_stats(...). I can't use the following
too:
>
> SELECT *
> FROM summary_stats(days.day_start, days.day_end) stats,
> divide_into_days('2003-06-01', '2003-07-01') days;
>
> (there was a discussion a few days ago about using subselects,
> but here's a slightly different case).
>
> I wonder if where's a way to do the trick without writing one more
> PL/PgSQL table function doing FOR row IN SELECT ... LOOP or using
> client-side loop?
>
Did you see
http://techdocs.postgresql.org/guides/SetReturningFunctions
Regards, Christoph
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Cain | 2003-08-04 15:25:36 | Re: EXTERNAL storage and substring on long strings |
Previous Message | evl | 2003-08-04 08:17:56 | How to check: is some key referenced from sometable |