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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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.

Browse pgsql-sql by date

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