* Tom Lane ([EMAIL PROTECTED]) wrote: > The reason for this behavior is that analyze.c attaches the CREATE TABLE > AS aliases to the targetlist (via applyColumnNames) before it processes > the ORDER BY clause. (So, "order by z2" works instead.) This seems > like a bug: one would expect that the aliases do not change the > semantics of the SELECT part of the command.
I'd tend to agree that it seems like a bug but I'm a little mystified as to why an 'order by' would be desired (or allowed) for a 'create table as' at all. Allowing it seems to imply it has some meaning. Just my 2c, Stephen
signature.asc
Description: Digital signature