Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id 9BDC02E002D
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Tue, 29 Apr 2008 04:20:57 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 65796-05
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Tue, 29 Apr 2008 04:20:47 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3])
	by developer.postgresql.org (Postfix) with ESMTP id 282322E004C
	for <pgsql-sql@postgresql.org>; Tue, 29 Apr 2008 04:20:49 -0300 (ADT)
Received: from DOMEXT-MTA by WEBACCESS.INDICATOR.BEwith Novell_GroupWise;
	Tue, 29 Apr 2008 09:20:47 +0200
Message-Id: <4816E863.A3DD.0030.0@indicator.be>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Tue, 29 Apr 2008 09:20:35 +0200
From: "Bart Degryse" <Bart.Degryse@indicator.be>
To: <pgsql-sql@postgresql.org>
Subject: Field Alias Alternative
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=__PartA980FA53.0__="
X-imss-version: 2.050
X-imss-result: Passed
X-imss-approveListMatch: *@indicator.be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/221
X-Sequence-Number: 30760

--=__PartA980FA53.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

Is there another way to quote a field alias (containing spaces) than with =
double quotes?
=20
This works:
SELECT actions.addresstypes.addresstype AS "Address Type" FROM actions.addr=
esstypes
=20
I would like something like this
SELECT actions.addresstypes.addresstype AS [Address Type] FROM actions.addr=
esstypes
=20
Is that possible?
Thanks for any ideas.

--=__PartA980FA53.0__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Is there another way to quote&nbsp;a field alias (containing spaces) =
than with double quotes?</DIV>
<DIV>&nbsp;</DIV>
<DIV>This works:</DIV>
<DIV>SELECT actions.addresstypes.addresstype AS "Address Type" FROM =
actions.addresstypes</DIV>
<DIV>&nbsp;</DIV>
<DIV>I would like something like this</DIV>
<DIV>
<DIV>SELECT actions.addresstypes.addresstype AS [Address Type] FROM =
actions.addresstypes</DIV>
<DIV>&nbsp;</DIV>
<DIV>Is that possible?</DIV>
<DIV>Thanks for any ideas.</DIV></DIV></BODY></HTML>

--=__PartA980FA53.0__=--