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