Re: [BUGS] BUG #2017: column labels ignored on selects from views

2005-11-03 Thread Tom Lane
"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

Re: [BUGS] BUG #2017: column labels ignored on selects from views

2005-11-03 Thread Tom Lane
"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

[BUGS] BUG #2017: column labels ignored on selects from views

2005-11-03 Thread Jolly Chen
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