Re: psql \df choose functions by their arguments - Mailing list pgsql-hackers

From Ian Lawrence Barwick
Subject Re: psql \df choose functions by their arguments
Date
Msg-id CAB8KJ=hu-4MCS_jmThoanNG3a-r9VCrrgapO+ww3Mzzq9b3Weg@mail.gmail.com
Whole thread Raw
In response to Re: psql \df choose functions by their arguments  (Greg Sabino Mullane <htamfids@gmail.com>)
Responses Re: psql \df choose functions by their arguments  (Greg Sabino Mullane <htamfids@gmail.com>)
List 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

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Moving other hex functions to /common
Next
From: Bharath Rupireddy
Date:
Subject: Re: logical replication worker accesses catalogs in error context callback