Re: Function args: TEXT -vs- VARCHAR? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Function args: TEXT -vs- VARCHAR?
Date
Msg-id 19211.1384367473@sss.pgh.pa.us
Whole thread Raw
In response to Re: Function args: TEXT -vs- VARCHAR?  (skinner@britvault.co.uk (Craig R. Skinner))
List pgsql-sql
skinner@britvault.co.uk (Craig R. Skinner) writes:
> On 2013-11-13 Wed 12:51 PM |, Tom Lane wrote:
>> The full SQL type syntax is allowed for declaring a function's arguments
>> and return value.  However, parenthesized type modifiers (e.g., the
>> precision field for type numeric) are discarded by CREATE FUNCTION.  Thus
>> for example "CREATE FUNCTION foo (varchar(10)) ..." is exactly the same as
>> "CREATE FUNCTION foo (varchar) ...".

> That note would be clear to this user.

OK, done like that.
        regards, tom lane



pgsql-sql by date:

Previous
From: skinner@britvault.co.uk (Craig R. Skinner)
Date:
Subject: Re: Function args: TEXT -vs- VARCHAR?
Next
From: Sergey Konoplev
Date:
Subject: Re: Function args: TEXT -vs- VARCHAR?