Re: BUG #19003: A SELECT that does not return a valid table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #19003: A SELECT that does not return a valid table
Date
Msg-id 1675174.1753911281@sss.pgh.pa.us
Whole thread Raw
In response to BUG #19003: A SELECT that does not return a valid table  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #19003: A SELECT that does not return a valid table
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Postgres: Queries are too slow after upgrading to PG17 from PG15
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #19003: A SELECT that does not return a valid table