Re: BUG #1364: using field names or table names with blanks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1364: using field names or table names with blanks
Дата
Msg-id 19451.1104366005@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #1364: using field names or table names with blanks  ("Pit Mueller" <fmi-soft@gmx.de>)
Список pgsql-bugs
"Pit Mueller" <fmi-soft@gmx.de> writes:
> MS SQL Server uses a quite elegant method for using field names and table
> names:

> select [field] from [table]
> f.ex. select [my field] from [the big table]

One man's "elegant" is another's "ugly and nonstandard".

> PostgreSQL 8.0 should support this notation too.

Not likely.  Use double quotes like the SQL standard tells you to:

    select "my field" from "the big table"

One would hope that SQL Server takes this too, since they claim some
amount of spec compliance.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: function return type for triggers in postgresql 8.0 rc2
Следующее
От: "keith berrington"
Дата:
Сообщение: BUG #1366: spam from yourselves