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