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@ll.mit.edu
MIT Lincoln Laboratory
244 Wood St.
Lexington, Massachusetts  02420-9108	(781) 981-2756