Hello 2008/7/17 ram subbu <[EMAIL PROTECTED]>: > Hi All, > Here i am facing a peculiar scenario. I have a query which always result > in 3 rows. There are two columns in the query result. I have to make the > result of 3 rows as a one row > select * from tab1; > > col1---col2 > --------------- > 1 5 > 2 38 > 3 50 > > the result should be >
select array_to_string(array(select col1 || '-' || col2 from tab1), '/'); regards Pavel Stehule > col > ---- > 1-5/2-38/3-50 > > Is there any possibilities? > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
