nolan(at)celery(dot)tssi(dot)com writes:
> This is the query I posted a performance question on, but I have a
> SQL standard question about it too:
> Why can't you define an alias on the primary table in an update query?
Because there's no such syntax in the SQL standard.
It seems like a reasonable extension, but looking at the grammar just
now, I think that we'd have to turn SET from an unreserved keyword to a
reserved word to make this work. Not sure how many peoples' databases
that would break ... but we'd probably get a few complaints ...
regards, tom lane