Re: psql \df choose functions by their arguments

Поиск
Список
Период
Сортировка
От Ian Lawrence Barwick
Тема Re: psql \df choose functions by their arguments
Дата
Msg-id CAB8KJ=hu-4MCS_jmThoanNG3a-r9VCrrgapO+ww3Mzzq9b3Weg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql \df choose functions by their arguments  (Greg Sabino Mullane <htamfids@gmail.com>)
Ответы Re: psql \df choose functions by their arguments  (Greg Sabino Mullane <htamfids@gmail.com>)
Список pgsql-hackers
Hi

I tried this patch out last year but was overrolled by Other Stuff before I got
around to providing any feedback, and was reminded of it just now when I was
trying to execute "\df somefunction text int" or similar, which had me
confused until I remembered it's not a feature yet, so it would
certainly be very
welcome to have this.

2020年11月3日(火) 23:27 Greg Sabino Mullane <htamfids@gmail.com>:
>
> Thanks for looking this over!
>
>>
>> some Abbreviations of common types are not added to the type_abbreviations[] Such as:
>>
>> Int8                => bigint
>
>
> I wasn't aiming to provide a canonical list, as I personally have never seen
> anyone use int8 instead of bigint when (for example) creating a function, but
> I'm not strongly opposed to expanding the list.

I have vague memories of working with "int8" a bit (possibly related to an
Informix migration), anyway it seems easy enough to add them for completeness
as someone (possibly migrating from another database) might wonder why
it's not working.

Just a small code readability suggestion - in exec_command_d(), it seems
neater to put the funcargs declaration in a block together with the
code with which uses it (see attached diff).


Regards

Ian Barwick


--
EnterpriseDB: https://www.enterprisedb.com

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Moving other hex functions to /common
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: logical replication worker accesses catalogs in error context callback