Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cktQH-00071Q-3j for pgsql-general@arkaria.postgresql.org; Mon, 06 Mar 2017 14:15:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cktQG-0001ca-Mq for pgsql-general@arkaria.postgresql.org; Mon, 06 Mar 2017 14:15:36 +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 1cktNo-0005ia-Pd for pgsql-general@postgresql.org; Mon, 06 Mar 2017 14:13:04 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cktNm-0004LG-6K for pgsql-general@postgresql.org; Mon, 06 Mar 2017 14:13:04 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 94A0B20888; Mon, 6 Mar 2017 09:13:00 -0500 (EST) Received: from frontend2 ([10.202.2.161]) by compute6.internal (MEProxy); Mon, 06 Mar 2017 09:13:00 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=aklaver.com; h=cc :content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc:x-sasl-enc; s=mesmtp; bh=G6ECEkO/GyPTv7W mGlGcTY6zDQ4=; b=nh6+CfczOVw6LK8roZpKTWPhVKVf7Utu0lOBqOjZHgDDD0u 2JmabFu8I6uNTDtg1aXU855EdxnloyKwleSa6mFs+XxxW5Rj8b7fL7meG10S/w9F kUIYfHHmw1/vWxqPdmuWXF2kyOfsALMWLuaXxxQ4Q392bnjx9pgqJB0majgg= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc:x-sasl-enc; s= smtpout; bh=G6ECEkO/GyPTv7WmGlGcTY6zDQ4=; b=Tuhgh3dObrxLwR5LPq5z 6Q1YLAv95wz46fzZH1eHezx/X0/v1aK/3YhB7llSjI72fdDqRNp1xWlXKiQvleFH IRPq+IVS/kUHKIxp2K8R4R7JEQcr1/tTSxErztlg2DppmMoQFKfAhUPO8Z5rbGOY PTnPNUx4nAQlX6II+6XSfyM= X-ME-Sender: X-Sasl-enc: mDIbu5ZMpVidvg3vhqULjwHeu5I4Hw+P04jiPJqqdSr4 1488809580 Received: from [192.168.1.2] (174-21-203-58.tukw.qwest.net [174.21.203.58]) by mail.messagingengine.com (Postfix) with ESMTPA id 035C124132; Mon, 6 Mar 2017 09:12:59 -0500 (EST) Subject: Re: Fwd: parameter type is unknown error To: =?UTF-8?Q?G=c3=bcnce_Kaya?= , Charles Clavadetscher References: <000401d29670$10e9d870$32bd8950$@swisspug.org> <001b01d29674$4b8c62f0$e2a528d0$@swisspug.org> Cc: pgsql-general@postgresql.org From: Adrian Klaver Message-ID: <4d7cd214-ff33-5eec-b6ab-0ec305ecf6e2@aklaver.com> Date: Mon, 6 Mar 2017 06:12:59 -0800 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -2.7 (--) 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 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; > > 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