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.pirvu@xxxxxxxxx> 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.
