Обсуждение: alias with spaces

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 ?

___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

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.