Re: alias with spaces

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.