Re: join from array or cursor - Mailing list pgsql-general

From Tom Lane
Subject Re: join from array or cursor
Date
Msg-id 5174.1250870751@sss.pgh.pa.us
Whole thread Raw
In response to Re: join from array or cursor  (Sam Mason <sam@samason.me.uk>)
Responses Re: join from array or cursor  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
Sam Mason <sam@samason.me.uk> writes:
> ... PG should instead arrange that the expression
> "t" is run exactly once and reuse the single result for all columns.

We might be able to do that based on the row-returning-subselect
infrastructure being discussed over here:
http://archives.postgresql.org/message-id/4087.1250867036@sss.pgh.pa.us
Don't hold your breath though ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Andrus Moor"
Date:
Subject: Error inserting data to bytea column in 8.4
Next
From: Tom Lane
Date:
Subject: Re: Out of memory on pg_dump