Hallo Adrian > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Adrian Klaver > Sent: Montag, 6. März 2017 15:13 > To: Günce Kaya <guncekaya14@xxxxxxxxx>; Charles Clavadetscher <clavadetscher@xxxxxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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.klaver@xxxxxxxxxxx > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general