Re: plpgsql arrays

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: plpgsql arrays
Date: 2009-04-03 14:28:34
Message-ID: alpine.DEB.2.00.0904031526080.21772@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 3 Apr 2009, Tom Lane wrote:
> Not unless you have sorted the inputs in some way that has more
> knowledge than the "equal" operator represents. Otherwise you can have
> elements drop out that might still be needed to match to a later
> left-hand element.

Of course. You certainly have to choose a sort order that works. Sorting
by the start field would be sufficient in this case.

Matthew

--
For those of you who are into writing programs that are as obscure and
complicated as possible, there are opportunities for... real fun here
-- Computer Science Lecturer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2009-04-03 14:45:25 Re: plpgsql arrays
Previous Message Tom Lane 2009-04-03 14:24:41 Re: plpgsql arrays