In PostgreSQL, how can you declare a variadic function that accepts arguments of differing types?

Question

It's definitely possible to define such a function through the C API as can be witnessed by looking at json_build_array() for example:

Unfortunately trying to create a SQL or pl/pgSQL function like this fails

CREATE OR REPLACE FUNCTION my_function( VARIADIC _args anyelement[]) RETURNS ...

and this is no surprise as the PostgreSQL documentation mentions that 'VARIADIC' only works for arrays (and it seems there is no such thing as an anyelement[]). Does anybody know how to get this working without having to write a C function ?

Don't have time for full answer. I can point you at here. Search for polymorphic. That will also lead you to Polymorphic Types. — Adrian Klaver
– Adrian Klaver, Commented Oct 21, 2020 at 15:18

Pavel Stehule · Accepted Answer · 2020-10-21 15:29:08Z

1

There is not possibility now. PLpgSQL and SQL languages are out of game, because there are not arrays with fields of different types. And PL/Perl or PL/Python just doesn't support, it what I know.

answered Oct 21, 2020 at 15:29

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

In PostgreSQL, how can you declare a variadic function that accepts arguments of differing types?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related