Re: Function args: TEXT -vs- VARCHAR?

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