Hallo Adrian > -----Original Message----- > From: [email protected] > [mailto:[email protected]] 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
