Re: [PATCH] Generate column names for subquery expressions
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Marti Raudsepp <marti@juffo.org>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-09-01T01:48:20Z
Lists: pgsql-hackers
Marti Raudsepp <marti@juffo.org> writes: > In current PostgreSQL versions, subquery expressions in the SELECT list > always generate columns with name "?column?" > ... > This patch improves on that: > select (SELECT 1 AS foo) => foo > select exists(SELECT 1) => exists > select array(SELECT 1) => array > Does this sound like a good idea? Seems like a lot of room for bikeshedding here, but we could certainly consider doing something. > Should I submit this to the CommitFest? Please. regards, tom lane