Thread: function format doesn't support values with variadic flag

function format doesn't support values with variadic flag

From
Pavel Stehule
Date:
Hello

this code should to work, but it doesn't

postgres=3D# select format('%s %s', variadic array['Hello','World']);
ERROR:  too few arguments for format

postgres=3D# create or replace function un(variadic integer[])
postgres-# returns setof int as $$ select unnest($1)$$ language sql;
CREATE FUNCTION
postgres=3D# select un(1,2,3,4);
 un
=E2=94=80=E2=94=80=E2=94=80=E2=94=80
  1
  2
  3
  4
(4 rows)

postgres=3D# select un(variadic array[1,2,3]);
 un
=E2=94=80=E2=94=80=E2=94=80=E2=94=80
  1
  2
  3
(3 rows)

A problem is in too simple evaluation of "any" parameter - without
check to "VARIADIC" flag

Regards

Pavel Stehule