Re: ambiguous column names in subqueries - Mailing list pgsql-hackers

From Greg Stark
Subject Re: ambiguous column names in subqueries
Date
Msg-id 87oehw3z0v.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: ambiguous column names in subqueries  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ambiguous column names in subqueries  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> select * from (select 1 as foo, 2 as foo) as x(foo1, foo2);

How is this different than simply listing all the columns instead of the "*"?

I still have the maintenance problem of having to edit the outer query every
time the list of columns from the inner query changes.

-- 
greg



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: ambiguous column names in subqueries
Next
From: John Hansen
Date:
Subject: Re: split_part bug