to_typemod(type_name) information function

Поиск
Список
Период
Сортировка
От Sophie Herold
Тема to_typemod(type_name) information function
Дата
Msg-id 225f6658-c531-7479-ba59-edf524f957d7@hemio.de
обсуждение исходный текст
Ответы Re: to_typemod(type_name) information function
Список pgsql-hackers
Hi,

I need to test a (user) given column type name, with one in the database
for equality. To this end, I have to do some kind of normalization (e.g.
'timestamptz(2)' to 'timestamp (2) with time zone'.)

Comparing the name alone is possible with to_regtype(type_name) or
::regtype. However, this ignores the 'typemod'.

I want to suggest a to_typemod(type_name) function which, combined with
to_regtype, would allow to decompose (and reconstruct) a type name
completely.

Best,
Sophie


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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Treating work_mem as a shared resource (Was: Parallel Hash take II)
Следующее
От: "Ian Corson"
Дата:
Сообщение: RE: unsubscribe