Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37555=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1VgbWr-0001dV-7N
 for pgsql-sql@arkaria.postgresql.org; Wed, 13 Nov 2013 14:34:49 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37555=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1VgbWq-0004bM-NF
 for pgsql-sql@arkaria.postgresql.org; Wed, 13 Nov 2013 14:34:48 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <adrian.klaver@gmail.com>) id 1VgbWq-0004bG-1k
 for pgsql-sql@postgresql.org; Wed, 13 Nov 2013 14:34:48 +0000
Received: from mail-pd0-f177.google.com ([209.85.192.177])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <adrian.klaver@gmail.com>) id 1VgbWi-0004dK-T7
 for pgsql-sql@postgresql.org; Wed, 13 Nov 2013 14:34:47 +0000
Received: by mail-pd0-f177.google.com with SMTP id v10so461739pde.36
 for <pgsql-sql@postgresql.org>; Wed, 13 Nov 2013 06:34:31 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:date:from:user-agent:mime-version:to:subject:references
 :in-reply-to:content-type:content-transfer-encoding;
 bh=jq8N9AEHS8X4EY1z16EPF8F/RZQwHvoDHICpTQffQ7o=;
 b=FKpsMkGvOmhSXQ4j5POzo/O5I8ysj237oV7EPDpvgr+UQ1cG0M6V0+JpM6756oq25k
 PgNhIwTikSlXlRvn4tOBdTXyOs+i6dFzh/1nFYQwz5kO2Vx6nOlSgKLYJ6ZCHE5ZLoM9
 BVIFlIk4N9VyykTzOXhU8yTDtXU//AA1wnX6x+ZBL0FD3K9oEvBZQHuZrGdSFsm7BWWq
 IQCdfPnQOEuD3IFE2IF8u/6oiRP9aVnORVzFHRLVJ4IumsHgfDVJoa9y5qsaL5qL7t2n
 CL914ZHiCdjJp2XjvHnF+Dp07dmIXi0N1XrvwoZJFAhnegc27N3CI+e8TzbdqlZ6RMQY
 oi5A==
X-Received: by 10.68.29.36 with SMTP id g4mr17599061pbh.145.1384353271441;
 Wed, 13 Nov 2013 06:34:31 -0800 (PST)
Received: from [192.168.1.2] (174-21-240-52.tukw.qwest.net. [174.21.240.52])
 by mx.google.com with ESMTPSA id qv8sm4672879pbc.31.2013.11.13.06.34.29
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Wed, 13 Nov 2013 06:34:30 -0800 (PST)
Message-ID: <52838DF0.8040708@gmail.com>
Date: Wed, 13 Nov 2013 06:34:24 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.0
MIME-Version: 1.0
To: "Craig R. Skinner" <skinner@britvault.co.uk>,
 pgsql-sql@postgresql.org
Subject: Re: Function args: TEXT -vs- VARCHAR?
References: <20131112181744.GA7522@teak.britvault.co.uk>
 <CAHZ=uVAOB9H9jS2BGnu9jDKosxapKY2_M+arf+-kC1fwCSgvfg@mail.gmail.com>
 <20131113130308.GA17439@teak.britvault.co.uk>
 <20131113141718.GA29223@teak.britvault.co.uk>
 <CAFj8pRBhCirj16X0-toyLg85mnJ=wa98V5U941Szw6aNnzifaw@mail.gmail.com>
 <20131113142515.GB29223@teak.britvault.co.uk>
In-Reply-To: <20131113142515.GB29223@teak.britvault.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 11/13/2013 06:25 AM, Craig R. Skinner wrote:
> On 2013-11-13 Wed 15:20 PM |, Pavel Stehule wrote:
>>     yes, it is fact. Typmod of function arguments is ignored - there are
>>     lot of discuss in archive on this topic
>
> Thanks for the update.
>
> An official note of the known limitation in these pages would be appreciated:
> http://www.postgresql.org/docs/current/static/sql-createfunction.html
> http://www.postgresql.org/docs/9.2/static/plpgsql-overview.html#PLPGSQL-ARGS-RESULTS

http://www.postgresql.org/docs/9.3/interactive/sql-createfunction.html
"
Notes

The full SQL type syntax is allowed for input arguments and return 
value. However, some details of the type specification (e.g., the 
precision field for type numeric) are the responsibility of the 
underlying function implementation and are silently swallowed (i.e., not 
recognized or enforced) by the CREATE FUNCTION command.
"

>
> Thanks,
>


-- 
Adrian Klaver
adrian.klaver@gmail.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql