Re: Range types

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Scott Bailey <artacus(at)comcast(dot)net>, hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Range types
Date: 2009-12-16 09:36:15
Message-ID: 87my1jjm5s.fsf@enterprise.technique.hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Albe Laurenz 2009-12-16 09:52:34 Re: Update on true serializable techniques in MVCC
Previous Message Simon Riggs 2009-12-16 09:14:44 Re: Hot Standby and prepared transactions