From: | "Charles Clavadetscher" <clavadetscher(at)swisspug(dot)org> |
---|---|
To: | "'Adrian Klaver'" <adrian(dot)klaver(at)aklaver(dot)com>, 'Günce Kaya' <guncekaya14(at)gmail(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Fwd: parameter type is unknown error |
Date: | 2017-03-06 14:20:47 |
Message-ID: | 00de01d29684$e108b760$a31a2620$@swisspug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Hallo Adrian
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Adrian Klaver
> Sent: Montag, 6. März 2017 15:13
> To: Günce Kaya <guncekaya14(at)gmail(dot)com>; Charles Clavadetscher <clavadetscher(at)swisspug(dot)org>
> Cc: pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Günce Kaya | 2017-03-07 04:18:06 | Re: Fwd: parameter type is unknown error |
Previous Message | Adrian Klaver | 2017-03-06 14:12:59 | Re: Fwd: parameter type is unknown error |
From | Date | Subject | |
---|---|---|---|
Next Message | Günce Kaya | 2017-03-07 04:18:06 | Re: Fwd: parameter type is unknown error |
Previous Message | Adrian Klaver | 2017-03-06 14:12:59 | Re: Fwd: parameter type is unknown error |