On Fri, Apr 3, 2009 at 9:32 AM, Matthew Wakeling <matt...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance