Home > mailing lists

"constructor" does not work as alias for me - Mailing list pgsql-admin

From	Marcus Strube
Subject	"constructor" does not work as alias for me
Date	October 18, 2018 18:44:21
Msg-id	CADzjXnyX8GbhHPZMoFXFyne9yRaqEGZLoAhc=T=tfBVybr_0kg@mail.gmail.com Whole thread Raw
Responses	Re: "constructor" does not work as alias for me
List	pgsql-admin

Hi,

the alias "constructor" does seem to be a problem.

select n as "constructor" from (VALUES (1), (2), (3)) AS t (n)

This gives this result: https://imgur.com/a/dM9eM06

psql for both gives the same result.

I am running the latest version from the "PostgreSQL Apt Repository" on Ubuntu 18.10 in desktop mode.

Regards,

Marcus

pgsql-admin by date:

Previous

From: Pierre Ochsenbein
Date: 18 October 2018, 09:46:34
Subject: Re: pgpool versus which tool?

Next

From: Andres Freund
Date: 18 October 2018, 19:02:21
Subject: Re: "constructor" does not work as alias for me