Gregory Stark escribió: > The upside is the convenience which after all is the same upside as most of > our spec grammar extensions. Many many programmers are accustomed to entering > ad-hoc queries of this form and forcing them to enter an alias for no purpose > is just silly pedanticism from their point of view. The portability of ad-hoc > queries is meaningless and if you don't refer to the alias in the query then > it's truly pointless.
So there's the compromise: allow not specifying an alias only if it's not used in the rest of the query at all, so the subquery would be effectively anonymous. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
