How can i combine two columns - Mailing list pgsql-novice

From Ville Jungman
Subject How can i combine two columns
Date
Msg-id F112A4BEnn74lGDrOxH0001410c@hotmail.com
Whole thread Raw
Responses Re: How can i combine two columns
List 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


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: locale error
Next
From: Peter Childs
Date:
Subject: Re: How can i combine two columns