PG Bug reporting form <noreply@postgresql.org> writes:
> SELECT 'John' AS nom,'James' AS nom
> returns a table with attributes nom and nom that I can see in the output.
> Returning a table that contains twice the same column should not be
> permitted.
There is pretty much zero chance that we will enforce that
restriction. It would break too much application code.
Also, it looks to me like there is no such requirement in
the SQL standard.
regards, tom lane