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 <clavadetsc...@swisspug.org >: > Hallo Adrian > > > -----Original Message----- > > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-owner@ > postgresql.org] On Behalf Of Adrian Klaver > > Sent: Montag, 6. März 2017 15:13 > > To: Günce Kaya <guncekay...@gmail.com>; Charles Clavadetscher < > clavadetsc...@swisspug.org> > > Cc: pgsql-general@postgresql.org > > 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 > > adrian.kla...@aklaver.com > > > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > -- Gunce Kaya
