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.98.2) (envelope-from ) id 1xBGUa-000000036iN-0hW9 for pgsql-docs@arkaria.postgresql.org; Mon, 28 Sep 2026 18:54:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xBGUZ-0000000Aytq-0jlX for pgsql-docs@arkaria.postgresql.org; Mon, 28 Sep 2026 18:54:23 +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.98.2) (envelope-from ) id 1xBCJu-00000009gDw-3UIh for pgsql-docs@lists.postgresql.org; Mon, 28 Sep 2026 14:27:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xBCJs-00000001h3O-2XEJ for pgsql-docs@lists.postgresql.org; Mon, 28 Sep 2026 14:27:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: Content-Transfer-Encoding:MIME-Version:Content-Type:Sender:Content-ID: Content-Description:In-Reply-To:References; bh=GODZG2flcu+oLdJ1sV2DoruVAKpvtvAI3BbdOTKUE04=; b=iHcVxaLpXjn7va8Nn4TvuYYIyW lgTIG/9T25FVtF3iIhXRD/62hRov1J5qAZeS3/hQWFRvkdD1R+FYH3fGn3XNgZqpBn5XsOuqh1zOV emWEGANO/79DGog7tMJ0cunPn/nNPvEr7ER8kE8sS+2AwPkWyC7AsPRjLj6nionfroihUawR65oZo bjPa0hktKAD5Hb2EHfR5uMQOpFUUisADKxzvbMKPrypCwdJmYxt6uL008KZIUYUrs88b5ZrJ/sErp 23vl28y10SHKg7clFE3SValkdFcIadIC9LvbX1+wInhQSzISMI1B2fME4bt5GkludWideLo1AOXBS D8aEkayw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1xBCJs-00512j-2L for pgsql-docs@lists.postgresql.org; Mon, 28 Sep 2026 14:27:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xBCJq-0000000Ehq4-2taQ for pgsql-docs@lists.postgresql.org; Mon, 28 Sep 2026 14:27:03 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Subject: Table 9.31. to_char Examples To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: y.saburov@gmail.com Reply-To: y.saburov@gmail.com, pgsql-docs@lists.postgresql.org Date: Mon, 28 Sep 2026 14:26:06 +0000 Message-ID: <179060556683.1026193.5885759110394852468@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/18/functions-matching.html Description: This is not true: ```html to_char(485, 'PL999') '+485' ``` add examples: ```psql db=3D# SELECT quote_literal(to_char(timestamp '2026-04-15','RM')); quote_literal --------------- 'IV ' (1 =D1=80=D1=8F=D0=B4=D0=BE=D0=BA) db=3D# SELECT quote_literal(to_char(timestamp '2026-04-15','FMRM')); quote_literal --------------- 'IV' (1 =D1=80=D1=8F=D0=B4=D0=BE=D0=BA) db=3D# SELECT quote_literal(to_char(timestamp '2026-12-31', 'rm')); quote_literal --------------- 'xii ' (1 =D1=80=D1=8F=D0=B4=D0=BE=D0=BA) ```