Re: Combining output of several fields in SQL query
| От | Aaron Bono |
|---|---|
| Тема | Re: Combining output of several fields in SQL query |
| Дата | |
| Msg-id | bf05e51c0609121207u2951fb6dl970a7835f27e29db@mail.gmail.com обсуждение исходный текст |
| Ответ на | Combining output of several fields in SQL query (Allan Kamau <kamauallan@yahoo.com>) |
| Ответы |
Re: Combining output of several fields in SQL query
|
| Список | pgsql-admin |
On 9/12/06, Allan Kamau <kamauallan@yahoo.com> wrote:
What does tableA look like (DDL and the data)?
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
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).
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
В списке pgsql-admin по дате отправления: