2010/3/29 Tom Lane <tgl@xxxxxxxxxxxxx>: > "Andrus" <kobruleht2@xxxxxx> writes: >> I changed unction name and tried: >> CREATE OR REPLACE FUNCTION unnest21(anyarray) >> RETURNS SETOF anyelement as $$ >> SELECT $1[i] FROM generate_series(1,4) g(i) >> $$ LANGUAGE sql; > >> select unnest21(string_to_array('23,2,3,4,5',',')); > >> In this case it returns only 4 rows. >> No idea what is happening. > > Well, the generate_series call is wrong for this use ... > > I think if it appeared to work before it was because the built-in > unnest() function was capturing the call. he uses 8.1. the bug is in "generate_series(1,>>>4<<<)" Pavel > > regards, tom lane > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general