Re: Function args: TEXT -vs- VARCHAR?

From: skinner(at)britvault(dot)co(dot)uk (Craig R(dot) Skinner)
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Function args: TEXT -vs- VARCHAR?
Date: 2013-11-13 18:04:36
Message-ID: 20131113180436.GA21703@teak.britvault.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Thanks,
--
Craig Skinner | http://twitter.com/Craig_Skinner | http://linkd.in/yGqkv7

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2013-11-13 18:31:13 Re: Function args: TEXT -vs- VARCHAR?
Previous Message David Johnston 2013-11-13 17:59:42 Re: Function args: TEXT -vs- VARCHAR?