Postgresql 9.6 functions argument casting int to string

Question

I have a function in my postgresql database that get as an argument text : func1 (arg1 text);

I summon it many times somethimes with strings as arguments and some times as interger. I know that in oracle we can send int as an argument to a function that get string argument. Is it possible in postgresql ? I must use casting ?

Erich Kitzmueller · Accepted Answer · 2017-08-21 11:48:34Z

2

In PostgreSQL, you do not have the same automatic casting like you have in Oracle. Instead, you have to cast explicitely:

select func1(134::text);

answered Aug 21, 2017 at 11:48

Erich Kitzmueller

37.1k5 gold badges85 silver badges104 bronze badges

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

6 Comments

JeyJ Over a year ago

There isnt any way to enable auto casting or something like that ?

Erich Kitzmueller Over a year ago

No that I am aware of; but you can create a second function, same name, different parameter type, that calls the original one: create function func1(double precision) returns xxx as 'select func1(arg1::text)' language sql;

JeyJ Over a year ago

Yes I realized that, I searched for a solution that might help me handle many data types. Well, Thanks !

Łukasz Kamiński Over a year ago

You can enable implicit cast in PostgreSQL. This will work: CREATE CAST (int AS text) WITH INOUT AS IMPLICIT;

Erich Kitzmueller Over a year ago

Wow, I wish I had known that 2 years earlier!

|

Collectives™ on Stack Overflow

Postgresql 9.6 functions argument casting int to string

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related