Postgres Pro
Downloads
Home   >   mailing lists

amateur nite out - Mailing list pgsql-novice

From D. Duccini
Subject amateur nite out
Date
Msg-id Pine.GSO.4.03.10101021643410.21081-100000@ra.bpsi.net
Whole thread Raw
In response to Re: ColdFusion sez this is valid SQL  ("D. Duccini" <duccini@backpack.com>)
Responses Re: amateur nite out  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-novice
Tree view 
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

-----------------------------------------------------------------------------
david@backpack.com            BackPack Software, Inc.        www.backpack.com
+1 651.645.7550 voice       "Life is an Adventure.
+1 651.645.9798 fax            Don't forget your BackPack!"
-----------------------------------------------------------------------------

pgsql-novice by date:

Previous
From: "D. Duccini"
Date:
Subject: and the monkey pushes the button
Next
From: "Brett W. McCoy"
Date:
Subject: Re: ColdFusion sez this is valid SQL