"Jolly Chen" <[EMAIL PROTECTED]> writes:
> Description:column labels ignored on selects from views
Fixed --- turns out the problem was in some recently-added code to
eliminate unnecessary SubqueryScan nodes. The resnames attached
to the SubqueryScan targetlist items have to be moved down
"Jolly Chen" <[EMAIL PROTECTED]> writes:
> testdb=# select sum as s from v1;
> sum
> -
>3
> (1 row)
Good catch. 8.0 and earlier get this right, so it's a regression we
induced somewhere in 8.1 development ... wonder where?
regards, tom lane
The following bug has been logged online:
Bug reference: 2017
Logged by: Jolly Chen
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1RC1
Operating system: Mac OS X 10.4.3
Description:column labels ignored on selects from views
Details:
Note how the column lab