Question about format_type function

Поиск
Список
Период
Сортировка
От Tony Caduto
Тема Question about format_type function
Дата
Msg-id 42509111.1030105@amsoftwaredesign.com
обсуждение исходный текст
Ответ на Re: Empty date  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: Question about format_type function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
The format_type function is great, except for the way it formats varchars,
it always returns Character Varying or whatever, it would be nice if it
had a option to return a short version of
these names.  i.e.

format_type(a.atttypid, a.atttypmod,true)  would return all short names

format_type(a.atttypid, a.atttypmod,false) would return full names

I don't know of any other system that shows varchars in this way, they
should just be formated as varchar(50).

If there is another way to do this without messy case statements please
let me know.


Thanks,

Tony





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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Empty date
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Strange plpgsql performance, diff plperl and plpgsql