Function args: TEXT -vs- VARCHAR?

Поиск
Список
Период
Сортировка
От skinner@britvault.co.uk (Craig R. Skinner)
Тема Function args: TEXT -vs- VARCHAR?
Дата
Msg-id 20131112181744.GA7522@teak.britvault.co.uk
обсуждение исходный текст
Ответы Re: Function args: TEXT -vs- VARCHAR?  (Luca Vernini <lucazeo@gmail.com>)
Re: Function args: TEXT -vs- VARCHAR?  (Sergey Konoplev <gray.ru@gmail.com>)
Список pgsql-sql
When writing (9.2) PostgreSQL functions, is it preferable to have text
or character varying args?

The tables the functions are updating/inserting into have character
varying columns.

I've used both in various places & want to unify.

Using character varying with an over length arg causes the function to
bomb out on calling, which seems the logical thing to do as the table
can't accept the data anyway.

Thoughts?
-- 
Craig Skinner | http://twitter.com/Craig_Skinner | http://linkd.in/yGqkv7



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

Предыдущее
От: Sergey Konoplev
Дата:
Сообщение: Re: Find datatype of a column during the backend flow
Следующее
От: Luca Vernini
Дата:
Сообщение: Re: Function args: TEXT -vs- VARCHAR?