Horton

Re: amateur nite out

Marc G. Fournier <scrappy@hub.org>

View thread View on postgr.es
From: The Hermit Hacker <scrappy@hub.org>
To: "D. Duccini" <duccini@backpack.com>
Cc: Pgsql-novice <pgsql-novice@postgresql.org>
Date: 2001-01-03T00:04:41Z
Lists: pgsql-novice 
On Tue, 2 Jan 2001, D. Duccini wrote:

>
> i think its time for afternoon coffee
>
> how do you select multiple columns but return them as a single column?
>
> ie, select lastname+', '+firstname as fullname from authors;
>
> of course it chokes on the + op

SELECT lastname || ', ' || firstname AS fullname FROM authors;