Skip site navigation (1) Skip section navigation (2)

Field Alias Alternative

From: "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Field Alias Alternative
Date: 2008-04-29 07:20:35
Message-ID: 4816E863.A3DD.0030.0@indicator.be (view raw or flat)
Thread:
Lists: pgsql-sql
Is there another way to quote a field alias (containing spaces) than with double quotes?
 
This works:
SELECT actions.addresstypes.addresstype AS "Address Type" FROM actions.addresstypes
 
I would like something like this
SELECT actions.addresstypes.addresstype AS [Address Type] FROM actions.addresstypes
 
Is that possible?
Thanks for any ideas.

pgsql-sql by date

Next:From: venkatDate: 2008-04-29 11:10:32
Subject: Reg:-How to make relationship more one table in PgSQL
Previous:From: Scott MarloweDate: 2008-04-29 03:31:17
Subject: Re: Truncate table at a certain size.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group