Dimitri Fontaine <dfonta...@hi-media.com> writes:
> Tom Lane <t...@sss.pgh.pa.us> writes:
>> foreach p2_member in unnest(p2) loop
>> p1 := array(select period_except(p1_member, p2_member)
>> from unnest(p1) p1_member);
>> end loop;
>>
>> But maybe it can be done in a single SQL command.
> Yeah, as soon as you have LATERAL, I think. Without it there's no way to
> compose SRF in SQL, AFAIK.
Hm, how would you do it with LATERAL? The problem is not so much
composition as the need for a variable number of rounds of composition.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
