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