Re: Range types - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: Range types
Date
Msg-id 87my1jjm5s.fsf@enterprise.technique.hi-media-techno.com
Whole thread Raw
In response to Re: Range types  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Range types  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@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.

Regards,
-- 
dim


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot Standby and prepared transactions
Next
From: "Albe Laurenz"
Date:
Subject: Re: Update on true serializable techniques in MVCC