Please don't top-post - it makes following the thread a lot harder. On Mon, Nov 21, 2016 at 4:15 PM, Armand Pirvu (home) <armand.pi...@gmail.com > wrote:
> Played with unnest but not much luck > If you want help you will need to show your work - ideally with examples that can execute with meaningful data on an empty database. The follow gives the expected results: DO $$ DECLARE foo text[]; foo1 text; delim text := ','; begin foo := ARRAY['one','two']::text[]; foo1 := array_to_string(foo, delim); RAISE NOTICE '%', foo1; END; $$; NOTICE: one,two David J.