Re: Function args: TEXT -vs- VARCHAR?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: skinner(at)britvault(dot)co(dot)uk (Craig R(dot) Skinner)
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Function args: TEXT -vs- VARCHAR?
Date: 2013-11-13 18:31:13
Message-ID: 19211.1384367473@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

skinner(at)britvault(dot)co(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sergey Konoplev 2013-11-14 07:41:35 Re: Function args: TEXT -vs- VARCHAR?
Previous Message Craig R. Skinner 2013-11-13 18:04:36 Re: Function args: TEXT -vs- VARCHAR?