Re: [GENERAL] Fwd: parameter type is unknown error

Поиск
Список
Период
Сортировка
От Günce Kaya
Тема Re: [GENERAL] Fwd: parameter type is unknown error
Дата
Msg-id CAAV2-mUKr62y5jvubzvTS9fSiw_ZH9cNE0NOnPZVN2gnAj7v6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Fwd: parameter type is unknown error  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
Список pgsql-general
Дерево обсуждения
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@swisspug.org>:
Hallo Adrian

> -----Original Message-----
> From: pgsql-general-owner@postgresql.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@gmail.com>; Charles Clavadetscher <clavadetscher@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.klaver@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




--
Gunce Kaya

В списке pgsql-general по дате отправления:

Предыдущее
От: "Charles Clavadetscher"
Дата:
Сообщение: Re: [GENERAL] Fwd: parameter type is unknown error
Следующее
От: Panagiotis Atmatzidis
Дата:
Сообщение: [GENERAL] Copy database to another host without data from specific tables