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/
Show quoted text
There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.