Postgres Pro
Downloads
Home   >   mailing lists

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

From Jens Glaser
Subject Re: [SQL] combining columns in select
Date
Msg-id Pine.LNX.4.05.9910012118510.217-100000@helena.jens.de
Whole thread Raw
In response to combining columns in select  (Doug Thistlethwaite <doug.t@deltanet.com>)
Responses Re: [SQL] combining columns in select  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
List pgsql-sql
Tree view 
Hi,

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)

regards,

-- 
Jens Glaser     Am Holderstrauch 13, 36041 Fulda, 0661/9429507    jens@jens.de

pgsql-sql by date:

Previous
From: Doug Thistlethwaite
Date:
Subject: combining columns in select
Next
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [SQL] combining columns in select