ql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of AM
Sent: Wednesday, November 23, 2011 1:46 PM
To: Postgres General
Subject: [GENERAL] On naming attributes in a WITH clause
Hello,
Is it possible to rename columns in a WITH clause which includes VALUES?
None of the following parse
Hello,
Is it possible to rename columns in a WITH clause which includes VALUES?
None of the following parse:
WITH map_table AS
(
VALUES ('1','r'),('2','w'),('3','a'),('4','d')
) AS (a,b)
SELECT * FROM map_table;
WITH map_table AS
(
VALUES ('1','r'),('2','w'),('3','a'),('4','d') AS t (a
