Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cktVd-0007HM-8j for pgsql-general@arkaria.postgresql.org; Mon, 06 Mar 2017 14:21:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cktVc-0004lv-P5 for pgsql-general@arkaria.postgresql.org; Mon, 06 Mar 2017 14:21:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cktVc-0004li-6U for pgsql-general@postgresql.org; Mon, 06 Mar 2017 14:21:08 +0000 Received: from aragorn.net-wizard.org ([138.201.127.29]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cktVV-0004XI-Ev for pgsql-general@postgresql.org; Mon, 06 Mar 2017 14:21:07 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.net-wizard.org (Postfix) with ESMTP id A094382270; Mon, 6 Mar 2017 15:21:00 +0100 (CET) X-Virus-Scanned: Gentoo amavisd-new at aragorn Received: from aragorn.net-wizard.org ([127.0.0.1]) by localhost (aragorn.net-wizard.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id mCzmLfRKqLPO; Mon, 6 Mar 2017 15:21:00 +0100 (CET) Received: from MTEC0211 (mtec-lee-dock-2-133.ethz.ch [129.132.6.133]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA384 (256/256 bits)) (No client certificate requested) (Authenticated sender: clavadetscher@swisspug.org) by aragorn.net-wizard.org (Postfix) with ESMTPSA id 3F7F782231; Mon, 6 Mar 2017 15:20:54 +0100 (CET) From: "Charles Clavadetscher" To: "'Adrian Klaver'" , =?utf-8?Q?'G=C3=BCnce_Kaya'?= Cc: References: <000401d29670$10e9d870$32bd8950$@swisspug.org> <001b01d29674$4b8c62f0$e2a528d0$@swisspug.org> <4d7cd214-ff33-5eec-b6ab-0ec305ecf6e2@aklaver.com> In-Reply-To: <4d7cd214-ff33-5eec-b6ab-0ec305ecf6e2@aklaver.com> Subject: Re: Fwd: parameter type is unknown error Date: Mon, 6 Mar 2017 15:20:47 +0100 Message-ID: <00de01d29684$e108b760$a31a2620$@swisspug.org> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 15.0 Thread-Index: AQEC2VxWTKByKmP5AyD42dQaO6xDmAJ2NHrZAgorHWkCTVCkHALx+/p6AXEOWm8BM1BmuaLENkjA Content-Language: de X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org Hallo Adrian > -----Original Message----- > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@post= gresql.org] On Behalf Of Adrian Klaver > Sent: Montag, 6. M=C3=A4rz 2017 15:13 > To: G=C3=BCnce Kaya ; Charles Clavadetscher > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Fwd: parameter type is unknown error >=20 > On 03/06/2017 04:36 AM, G=C3=BCnce 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. >=20 > If I am following correctly could not the function be eliminated by using= ?: >=20 > 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 >=20 > -- > Adrian Klaver > adrian.klaver@aklaver.com >=20 >=20 > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general --=20 Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general