Woops, figured it out. Just needed to declare the num_var := ''; On Sep 11, 10:45 pm, Nick <nboutel...@gmail.com> wrote: > CREATE FUNCTION test() RETURNS text > LANGUAGE plpgsql > AS $$DECLARE > num_var TEXT; > BEGIN > FOR i IN 1..10 LOOP > num_var := num_var || ',' || i; > END LOOP; > RETURN num_var; > END;$$; > > SELECT test(); > > returns NULL
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general