Robert Haas <robertmh...@gmail.com> writes: > On Sun, Aug 2, 2009 at 12:06 PM, Andres Freund<and...@anarazel.de> wrote: >> - Currently a value scan looks like »Values Scan on "*VALUES*"« What about >> adding its alias at least in verbose mode? This currently is inconsistent >> with >> other scans.
> I don't know why this doesn't work, but I think it's unrelated to this patch. If you mean something like regression=# explain select * from (values(1)) ss; QUERY PLAN ------------------------------------------------------------- Values Scan on "*VALUES*" (cost=0.00..0.01 rows=1 width=4) (1 row) I think the reason is that the alias applies to a SubqueryScan node that later gets optimized away. The VALUES per se doesn't have an alias. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers