[pgpool-hackers: 3688] Re: enable specific argument name for function in pgpool_adm

[Tatsuo Ishii]

Hi Houzj (and sherlockcpp),

> Hi pgpool hackers,
> 
> When using pgpool_adm, we call the function as follows:
> 
>   SELECT * FROM pcp_node_info(1,'',11001,'t-ishii','t-ishii');
> 
> However, Sometimes we want to call the function with specific argument name.
> 
> such as:
>    SELECT * FROM pcp_node_info(node_id := 1, host := '',port := 11001, username := 't-ishii', password := 't-ishii');
> 
> In this case, the sql may looks more readable and we can also change the order of param.
> 
> I think it will be better to support specific argument name for pgpgool_adm func.
> 
> what do you think?

I think this is a great idea.

> See the attachment for the patch(master branch).

You don't need to update pgpool_adm--1.0 and others. The only
necessary patch is for pgpool_adm--1.3.sql. Also you need patches for
pgpool_adm manual.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp