| 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 15:51:13 |
| Message-ID: | 20131113155113.GA26600@teak.britvault.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 2013-11-13 Wed 06:34 AM |, Adrian Klaver wrote:
>
> 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.
> "
>
That's rather vague..... "... some details ..."
An explicit table of datatype & what's "silently swallowed" would be
valuable to clarify this topic that's said to be often repeatedly asked.
Cheers,
--
Craig Skinner | http://twitter.com/Craig_Skinner | http://linkd.in/yGqkv7
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-11-13 16:36:42 | Re: Function args: TEXT -vs- VARCHAR? |
| Previous Message | Adrian Klaver | 2013-11-13 14:34:24 | Re: Function args: TEXT -vs- VARCHAR? |