Re: alias with spaces

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: alias with spaces
Дата
Msg-id 20020910194219.C17121@svana.org
обсуждение исходный текст
Ответ на alias with spaces  (Mourad Dhambri <mourad_dhambri@yahoo.fr>)
Список pgsql-general
On Tue, Sep 10, 2002 at 11:37:09AM +0200, Mourad Dhambri wrote:
> Hi,
> I have an sql query on postgres then includes alias.
> In SQL Server, when there are spaces in the alias, I
> used to put it between brackets [], but in Postgres it
> doesn't work. why ?

Postgres follows the SQL standard. Use double quotes ("). Note that this
will make all your identifiers case-sensetive.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

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

Предыдущее
От: Mourad Dhambri
Дата:
Сообщение: alias with spaces
Следующее
От: Joachim von Thadden
Дата:
Сообщение: concatenation of strings