Good morning, Sorry for delay. I looked at your suggestions and also tried all of them.
Charles, thank you for your advise. I changed my function structure as you said and I executed the function as Samed mentioned so It works now. I did not want to use cast for varchar parameters cause in my previous functions, I didn't require it. I knew this problem is not only associated with varchar parameters due to my experienced. Thank you for sharing your experiences. I could accomplished this case with your helps. Regards, Gunce 2017-03-06 17:20 GMT+03:00 Charles Clavadetscher <[email protected] >: > Hallo Adrian > > > -----Original Message----- > > From: [email protected] [mailto:pgsql-general-owner@ > postgresql.org] On Behalf Of Adrian Klaver > > Sent: Montag, 6. März 2017 15:13 > > To: Günce Kaya <[email protected]>; Charles Clavadetscher < > [email protected]> > > Cc: [email protected] > > Subject: Re: [GENERAL] Fwd: parameter type is unknown error > > > > On 03/06/2017 04:36 AM, Günce Kaya wrote: > > > Hi Charles, > > > > > > You are right about parameter types. When I use function with cast as > > > you mentioned, I don't see "unknown". I see data types. but still > > > doesn't insert with my custom function. It's really weird cause I did > > > same thing for different function and It works. > > > > If I am following correctly could not the function be eliminated by > using?: > > > > insert into cargo.invoice ( orderid, .... ) RETURNING id; > > Yes, of course. I assume that this was a simplified example from the OP. > Bye > Charles > > > > Regards, > > > > > > Gunce > > > > -- > > Adrian Klaver > > [email protected] > > > > > > -- > > Sent via pgsql-general mailing list ([email protected]) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > -- Gunce Kaya
