Re: alias with spaces - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: alias with spaces
Date
Msg-id 20020910194219.C17121@svana.org
Whole thread Raw
In response to alias with spaces  (Mourad Dhambri <mourad_dhambri@yahoo.fr>)
List 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 by date:

Previous
From: Mourad Dhambri
Date:
Subject: alias with spaces
Next
From: Joachim von Thadden
Date:
Subject: concatenation of strings