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

[Hou, Zhijie]

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?

See the attachment for the patch(master branch).

Best regards,
houzj(sherlockcpp)




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200701/b2f4e3b2/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_adm--1.0.sql.patch
Type: application/octet-stream
Size: 4417 bytes
Desc: pgpool_adm--1.0.sql.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200701/b2f4e3b2/attachment-0007.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_adm--1.0--1.1.sql.patch
Type: application/octet-stream
Size: 1673 bytes
Desc: pgpool_adm--1.0--1.1.sql.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200701/b2f4e3b2/attachment-0008.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_adm--1.1.sql.patch
Type: application/octet-stream
Size: 4575 bytes
Desc: pgpool_adm--1.1.sql.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200701/b2f4e3b2/attachment-0009.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_adm--1.1--1.2.sql.patch
Type: application/octet-stream
Size: 2064 bytes
Desc: pgpool_adm--1.1--1.2.sql.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200701/b2f4e3b2/attachment-0010.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_adm-1.2.sql.patch
Type: application/octet-stream
Size: 4702 bytes
Desc: pgpool_adm-1.2.sql.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200701/b2f4e3b2/attachment-0011.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_adm-1.2-1.3.sql.patch
Type: application/octet-stream
Size: 2103 bytes
Desc: pgpool_adm-1.2-1.3.sql.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200701/b2f4e3b2/attachment-0012.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_adm-1.3.sql.patch
Type: application/octet-stream
Size: 6730 bytes
Desc: pgpool_adm-1.3.sql.patch
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200701/b2f4e3b2/attachment-0013.obj>