Re: plpgsql arrays - Mailing list pgsql-performance

From Robert Haas
Subject Re: plpgsql arrays
Date
Msg-id 603c8f070904030647u1c92e13ew53612ac0011ed7c1@mail.gmail.com
Whole thread Raw
In response to plpgsql arrays  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: plpgsql arrays
List pgsql-performance
On Fri, Apr 3, 2009 at 9:32 AM, Matthew Wakeling <matthew@flymine.org> wrote:
> I'm writing a plpgsql function that effectively does a merge join on the
> results of two queries. Now, it appears that I cannot read the results of
> two queries as streams in plpgsql, so I need to copy the contents of one
> query into an array first, and then iterate over the second query
> afterwards.

Why not just use SQL to do the join?

...Robert

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Rewriting using rules for performance
Next
From: Matthew Wakeling
Date:
Subject: Re: Rewriting using rules for performance