Re: Is there a bug in FOR i IN 1..10 LOOP (8.4.4)?

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