Re: [PATCH] Generate column names for subquery expressions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marti Raudsepp <marti(at)juffo(dot)org>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] Generate column names for subquery expressions
Date: 2011-09-01 01:48:20
Message-ID: 9810.1314841700@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Marti Raudsepp <marti(at)juffo(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-09-01 01:54:20 Re: [GENERAL] pg_upgrade problem
Previous Message Inoue, Hiroshi 2011-09-01 00:34:36 Re: setlocale() and gettext on Windows revisited