Da documentação [1]: "In the SQL standard, the optional key word AS can be omitted before an output column name whenever the new column name is a valid column name (that is, not the same as any reserved keyword). PostgreSQL is slightly more restrictive: AS is required if the new column name matches any keyword at all, reserved or not. Recommended practice is to use AS or double-quote output column names, to prevent any possible conflict against future keyword additions."
Ou seja, impossível. [1] http://www.postgresql.org/docs/8.4/interactive/sql-select.html -- ********************************************** Tiago J. Adami http://www.adamiworks.com ********************************************** 2009/9/21 Edimar Rangel <[email protected]> > Olá senhores! > > Na empresa onde trabalho estamos fazendo uma migração do Firebird, SQL > Server, para o PostgreSql 8.3, nos selects existentes no sistema, não > usávamos AS, por ser opcional nos bancos citados. No caso das tabelas, já > percebemos que é possível, o AS é opcional, mas será possível, no > postgresql, criar alias para COLUNAS, sem o uso de AS? > > Att. > > Edimar Rangel > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > >
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
