Re: Function args: TEXT -vs- VARCHAR?

Поиск
Список
Период
Сортировка
От skinner@britvault.co.uk (Craig R. Skinner)
Тема Re: Function args: TEXT -vs- VARCHAR?
Дата
Msg-id 20131113155113.GA26600@teak.britvault.co.uk
обсуждение исходный текст
Ответ на Re: Function args: TEXT -vs- VARCHAR?  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: Function args: TEXT -vs- VARCHAR?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Function args: TEXT -vs- VARCHAR?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Function args: TEXT -vs- VARCHAR?