Re: Combining output of several fields in SQL query

["Aaron Bono" <postgresql@xxxxxxxxxx>]

On 9/12/06, Allan Kamau <kamauallan@xxxxxxxxx> wrote:

Hi all,
This is a plain simple sql question appologies for
posting it here.

Am looking for a way of combining values from several
fields(and introducting value separators).

select field2+"_"+field1 from tableA;

I've tried
select field2||'_'||field1 from tableA;
I get "1" as the result(which is not what I want).

 

What does tableA look like (DDL and the data)?

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================