From: | Günce Kaya <guncekaya14(at)gmail(dot)com> |
---|---|
To: | Charles Clavadetscher <clavadetscher(at)swisspug(dot)org> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Fwd: parameter type is unknown error |
Date: | 2017-03-07 04:18:06 |
Message-ID: | CAAV2-mUKr62y5jvubzvTS9fSiw_ZH9cNE0NOnPZVN2gnAj7v6g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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 <clavadetscher(at)swisspug(dot)org
>:
> Hallo Adrian
>
> > -----Original Message-----
> > From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner@
> postgresql.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
>
>
--
Gunce Kaya
From | Date | Subject | |
---|---|---|---|
Next Message | Panagiotis Atmatzidis | 2017-03-07 07:02:20 | Copy database to another host without data from specific tables |
Previous Message | Charles Clavadetscher | 2017-03-06 14:20:47 | Re: Fwd: parameter type is unknown error |
From | Date | Subject | |
---|---|---|---|
Next Message | Ghosh, Snehashish | 2017-03-20 13:12:05 | Equivalent data type for SQL_Variant not found |
Previous Message | Charles Clavadetscher | 2017-03-06 14:20:47 | Re: Fwd: parameter type is unknown error |