Sending string as text to function POSTGRESQL

Question

I have the next function : func2(text a, text b)

I have another function func1. In func1 I summon func2 : PERFORM func2('aa',b). b is a text variable that I initialize.

I get the next error : function func2(unkown,text) does not exist.

any help ? Is there a way to convery string to text ?

Christian Stade-Schuldt · Accepted Answer · 2017-07-17 11:02:32Z

3

You can explicitly cast your String to Text by calling the function with

 func2('aa' :: TEXT,b)

answered Jul 17, 2017 at 11:02

4,8717 gold badges38 silver badges31 bronze badges

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

1 Answer 1