Re: [SQL] combining columns in select - Mailing list pgsql-sql

From D'Arcy" "J.M." Cain
Subject Re: [SQL] combining columns in select
Date
Msg-id m11XaFN-0000c2C@druid.net
Whole thread Raw
In response to Re: [SQL] combining columns in select  (Jens Glaser <jens@helena.jens.de>)
Responses Re: [SQL] combining columns in select  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-sql
Thus spake Jens Glaser
> On Sat, 2 Oct 1999, Doug Thistlethwaite wrote:
> >    select lname + ', ' + fname as NAME from table ...
> 
> I think this is a parser bug. I recall there is a simple workaround:
> 
> select (lname + ', ') + fname ... (use braces)

While you are correct in your solution, it isn't a parser bug.  It just
follows the spec.  There has been talk of allowing the first form as
an extension.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


pgsql-sql by date:

Previous
From: Jens Glaser
Date:
Subject: Re: [SQL] combining columns in select
Next
From: raptor
Date:
Subject: Re: [SQL] How about a postgreSQL cookbook?