agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@gmail.com>
To: Craig R. Skinner <skinner@britvault.co.uk>
To: pgsql-sql@postgresql.org
Subject: Re: Function args: TEXT -vs- VARCHAR?
Date: Wed, 13 Nov 2013 06:34:24 -0800
Message-ID: <52838DF0.8040708@gmail.com> (raw)
In-Reply-To: <20131113142515.GB29223@teak.britvault.co.uk>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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
view thread (17+ messages) latest in thread
Message-ID: <52838DF0.8040708@gmail.com>
Permalink: ../52838DF0.8040708@gmail.com/
Also on: postgresql.org/message-id/52838DF0.8040708@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@gmail.com, skinner@britvault.co.uk
Subject: Re: Function args: TEXT -vs- VARCHAR?
In-Reply-To: <52838DF0.8040708@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox