Re: [GENERAL] Problem about pgsql's column alias
От | Kevin Brown |
---|---|
Тема | Re: [GENERAL] Problem about pgsql's column alias |
Дата | |
Msg-id | 20030415003518.GZ1833@filer обсуждение исходный текст |
Ответ на | Re: [GENERAL] Problem about pgsql's column alias (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: [GENERAL] Problem about pgsql's column alias
|
Список | pgsql-hackers |
Tom Lane wrote: > Peter Eisentraut <peter_e@gmx.net> writes: > > Tom Lane writes: > >> AS is not optional in Postgres, and will never be so unless we choose to > >> drop support for postfix operators, which I consider an unlikely choice. > > > Well, we could drop the support for postfix operators in aliasing clauses > > that omit the AS. > > I think it would be a bad idea in any case; it would mask errors too > easily. For example, you meant to say "SELECT a + b, ..." but wrote > "SELECT a b, ...". Or how about this: > SELECT 'foo'::character varying > Is "varying" an alias or part of the type name? Shouldn't we be deprecating the use of :: in favor of the SQL-standard CAST()? -- Kevin Brown kevin@sysexperts.com
В списке pgsql-hackers по дате отправления: