Create function that accept arguments of any type (like concat)

Question

How can I create function that accepts arguments of any type.

I can create function like this: CREATE FUNCTION test(anyelement,anyelement) ...

But when I call it, I have to present arguments of same type:

SELECT test(1,2); -- ok

But:

SELECT test('lalala',2); -- error

Can I create a function that will accept arguments of any type, then cast them to string and do something with this strings.

So, can I create function that will look like concat(str "any" [, str "any" [, ...] ])

UPD: updated second example

ERROR: function test(character varying, integer) does not exist — Yavanosta
– Yavanosta, Commented May 28, 2012 at 8:37

Erwin Brandstetter · Accepted Answer · 2012-05-28 09:20:54Z

4

There is a simple alternative. Every type can be cast to text. You can just create a function:

CREATE FUNCTION test(text, text [,text [, ...]]) ...

And call it:

SELECT test('lalala'::text,2::text);

Just cast each argument to text explicitly.

answered May 28, 2012 at 9:20

668k159 gold badges1.2k silver badges1.3k bronze badges

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

1 Answer 1