How can i combine two columns

From: "Ville Jungman" <ville_jungman(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: How can i combine two columns
Date: 2003-02-12 10:53:10
Message-ID: F112A4BEnn74lGDrOxH0001410c@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi

how can i combine too cols to one.

col1 | col2
-----+-----
1 | 3
2 | 5

select combine(col1,col2) from table; (or whatever the command will be)
should give something like:

combine
-------
1
3
2
5

ville jungman, ulvilantie 3 b 11, 00350 helsinki, finland
tel. + 358 - 9 - 225 4482 , http://www.kolumbus.fi/vilmak
usko Herraan Jeesukseen, niin sin pelastut. (apt. 16:31)

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Peter Childs 2003-02-12 11:40:14 Re: How can i combine two columns
Previous Message Tom Lane 2003-02-12 07:51:27 Re: locale error