Casey Allen Shobe <cshobe(at)secureworks(dot)net> writes:
> In the following statement (which works), if I s/ps."usesysid"/"UID"/ in the
> two innermost subselects (such that it refers to the declared alias rather
> than the true column name), it fails. In DB2, it works in similar
I find that hard to believe. If true, DB2 is broken. An output-column
alias should not be visible in expressions for other output columns.
There are obvious circularity problems with allowing such a thing.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Casey Allen Shobe||Date: 2002-09-15 15:45:53|
|Subject: Re: Postgres storing time in strange manner|
|Previous:||From: pgsql-bugs||Date: 2002-09-15 15:12:03|
|Subject: Bug #768: Wrong special characters handling in Java|