Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1uxVdP-00F6qe-SS
	for pgsql-docs@arkaria.postgresql.org; Sat, 13 Sep 2025 19:10:08 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1uxVdM-006Laf-Li
	for pgsql-docs@arkaria.postgresql.org; Sat, 13 Sep 2025 19:10:05 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <kes-kes@yandex.ru>)
	id 1uxVdM-006LaX-9i
	for pgsql-docs@lists.postgresql.org; Sat, 13 Sep 2025 19:10:05 +0000
Received: from forward501d.mail.yandex.net ([178.154.239.209])
	by makus.postgresql.org with smtp (Exim 4.96)
	(envelope-from <kes-kes@yandex.ru>)
	id 1uxVdJ-000EiP-0k
	for pgsql-docs@lists.postgresql.org;
	Sat, 13 Sep 2025 19:10:03 +0000
Received: from mail-nwsmtp-smtp-production-main-74.iva.yp-c.yandex.net
 (mail-nwsmtp-smtp-production-main-74.iva.yp-c.yandex.net
 [IPv6:2a02:6b8:c0c:7601:0:640:48ae:0])
	by forward501d.mail.yandex.net (Yandex) with ESMTPS id D271581379;
	Sat, 13 Sep 2025 22:09:57 +0300 (MSK)
Received: by mail-nwsmtp-smtp-production-main-74.iva.yp-c.yandex.net
 (smtp/Yandex) with ESMTPSA id p9TVw0TMQSw0-RG1YC6Yu;
	Sat, 13 Sep 2025 22:09:54 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail;
	t=1757790595; bh=NaAD1Bg1IfycwXMzJ/yrSmBGjrnpeTpTLJTqD2E0glc=;
	h=In-Reply-To:Message-ID:Subject:References:To:From:Date;
	b=QC3xoFwW4adQ/AOzSe7BeXlU7Dedid8icDFay4HmUKV1zB2inxD+hqlpZnGX1VgVl
	 zcfNee/nfzAXJFhID8qtbPaZV/09GKnYJEWAKZucEkWLYSJZlkC76y6TNZEcNFlM5t
	 shm5B+zQDxucKXHvwyPXEQW6kSiEufQwWbmE97yM=
Authentication-Results: 
 mail-nwsmtp-smtp-production-main-74.iva.yp-c.yandex.net;
 dkim=pass header.i=@yandex.ru
Date: Sat, 13 Sep 2025 15:09:51 -0400
From: Eugen Konkov <kes-kes@yandex.ru>
Message-ID: <33902929.20250913150951@yandex.ru>
To: PG Doc comments form <noreply@postgresql.org>,
 pgsql-docs@lists.postgresql.org
Subject: Re: Autocompletion for \sf does not work if there is more than one
 function
In-Reply-To: <175772491451.851.7568162483004370199@wrigleys.postgresql.org>
References: <175772491451.851.7568162483004370199@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/33902929.20250913150951%40yandex.ru>
Precedence: bulk

Hello PG,

Friday, September 12, 2025, 8:55:14 PM, you wrote:

> The following documentation comment has been logged on the website:

> Page: https://www.postgresql.org/docs/17/app-psql.html
> Description:

test=>> \sf+ app_con<TAB><TAB>

test=>> \sf+ app_config
> ERROR:  more than one function named "app_config"

> I expect to see arguments types: void or jsonb like:
test=>> \sf app_con<TAB><TAB>
> void jsonb

> Because definition for those functions are:
>  Schema |    Name    | Result data type |

> --------+------------+------------------+------------------------------------------------>
>  public | app_config | void             | config jsonb

>  public | app_config | jsonb            | keys text[] DEF

> Best regards.


btw autocompletion for "DROP FUNCTION" works as expected
=> drop function app_config ( 
jsonb)   text)    text[])  

I expect the similar behaviour for \sf+ 

-- 
Best regards,
Eugen Konkov