Re: amateur nite out

On Tue, 02 Jan 2001, D. Duccini wrote:
> 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

This needs to be double vertical bars, not plus signs:

select lastname || ', ' || firstname as fullname from authors;

In psql, the "\do" command (list operators), shows:

op |left_arg |right_arg |result |description
---+----------+----------+---------+-----------------------------------------
...
|| |text |text |text |concatenate

--
George Young, Rm. L-204 gry(at)ll(dot)mit(dot)edu
MIT Lincoln Laboratory
244 Wood St.
Lexington, Massachusetts 02420-9108 (781) 981-2756