Re: BUG #19003: A SELECT that does not return a valid table
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: alexandrebailly1955@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Date: 2025-07-30T21:34:41Z
Lists: 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