"Eric B. Ridge" <eebbrr@gmail.com> writes:
> However, why is
> select table.* foo from table
> allowed? What does that even mean?
Doesn't mean anything, I think --- the SQL standard seems to exclude it.
It's fairly hard to prevent it at the grammar level, since we regard
"foo.*" as a type of primitive expression, but I suspect it might be a
good idea for transformTargetList to throw an error instead of silently
ignoring the column label.
regards, tom lane