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

From Hou, Zhijie
Subject RE: psql \df choose functions by their arguments
Date
Msg-id af4491f21b26449fbe8e6ef59b7fc9e3@G08CNEXMBPEKD05.g08.fujitsu.local
Whole thread Raw
In response to Re: psql \df choose functions by their arguments  (David Christensen <david@pgguru.net>)
Responses Re: psql \df choose functions by their arguments  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-hackers
Hi

(sorry forget to cc the hacklist)

> Improve psql \df to choose functions by their arguments

I think this is useful.

I found some comments in the patch.

1.
> * Abbreviations of common types is permitted (because who really likes 
> to type out "character varying"?), so the above could also be written as:

some Abbreviations of common types are not added to the type_abbreviations[] Such as:

Int8                => bigint
Int2                => smallint
Int4 ,int           => integer
Float4              => real
Float8,float,double => double precision
(as same as array type)

Single array seems difficult to handle it, may be we can use double array or use a struct.

2.
And I think It's better to update '/?' info about '\df[+]' in function slashUsage(unsigned short int pager).

Best regards,
houzj



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Dereference before NULL check (src/backend/storage/ipc/latch.c)
Next
From: Pavel Borisov
Date:
Subject: Re: [PATCH] Automatic HASH and LIST partition creation