2009/9/21 Tiago Adami <[email protected]>: > 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 >
Apenas uma observação: O AS é obrigatório para todas as versões anteriores a 8.4. Veja as release notes da versão 8.4: http://www.postgresql.org/docs/current/interactive/release-8-4.html E.2.3.3. Queries . Allow AS to be optional when specifying a SELECT (or RETURNING) column output label (Hiroshi Saito) This works so long as the column label is not any PostgreSQL keyword; otherwise AS is still needed. Osvaldo _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
