You could then use one of the other array functions to manipulate that array.
But given that you are appending strings to each other in your example, you can also just use the string_agg function from that same page - assuming you are on 9.0. It looks like that function isn't available before 9.0
Hi, I am totally new to PostgreSQL and this is my first script. Can anyone please help me with my following requirement I have script that returns 1 column and 40 rows. My requirement is update this existing script to show all the 40 rows data in a single row as a string.
For example The current script returns, something like this Tom Tad Max Ted
I have to update the existing script to show the above results as follow Tom || Tad || Max || Ted Something like colace in Ms sql