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

From skinner@britvault.co.uk (Craig R. Skinner)
Subject Re: Function args: TEXT -vs- VARCHAR?
Date
Msg-id 20131113180436.GA21703@teak.britvault.co.uk
Whole thread Raw
In response to Re: Function args: TEXT -vs- VARCHAR?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Function args: TEXT -vs- VARCHAR?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-sql by date:

Previous
From: David Johnston
Date:
Subject: Re: Function args: TEXT -vs- VARCHAR?
Next
From: Tom Lane
Date:
Subject: Re: Function args: TEXT -vs- VARCHAR?