From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | "Craig R(dot) Skinner" <skinner(at)britvault(dot)co(dot)uk>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Function args: TEXT -vs- VARCHAR? |
Date: | 2013-11-13 14:34:24 |
Message-ID: | 52838DF0.8040708@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Craig R. Skinner | 2013-11-13 15:51:13 | Re: Function args: TEXT -vs- VARCHAR? |
Previous Message | Craig R. Skinner | 2013-11-13 14:25:15 | Re: Function args: TEXT -vs- VARCHAR? |