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 ) id 1r5srs-00FfTL-8Q for pgsql-docs@arkaria.postgresql.org; Wed, 22 Nov 2023 19:26:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r5srq-00C8u6-Lg for pgsql-docs@arkaria.postgresql.org; Wed, 22 Nov 2023 19:26:34 +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 ) id 1r5srq-00C8ty-9Y for pgsql-docs@lists.postgresql.org; Wed, 22 Nov 2023 19:26:34 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r5srn-006r1M-GN for pgsql-docs@postgresql.org; Wed, 22 Nov 2023 19:26:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2023062407; h=In-Reply-To:Content-Transfer-Encoding:Content-Type: MIME-Version:References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To: Content-ID:Content-Description; bh=+X3z6iuiNt3jeAqRed0EK9kk/RjY4+WPAV5WUR5mMbY=; b=AJO6q7mkjJzUnVc9MaDuCe/stx 7QO9j4LCEqGX5AyfiB1+xgGwd8vjZ2TJaGgMxUSjejni87o4NweXt6m4htYBs9aYyCcxuzTr06y6F v4ngMJ9L2MPQ9z2unzoAZZ02UuIRtYRCFoZ/+TO3iIkVrLo8HBIMC+fLo4U0hFP/JzE6ZZJnbT4Yz Z5QZV9fo1tap+P9D/YpF1JBdzKrMbO6FRy/DE+XLJ/NCuefgQw+VnKioGI30TvUr4FJLbD3w/KOdp DCyMQQA4+Gph6m2IbY7U1MGGvo0Q0NxEFwgZ025qgDBIneSE1CEQsok4Q0+I08yYAAD1sXUwEWk2R Pa+qSkRg==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1r5srk-00B0cL-0I; Wed, 22 Nov 2023 14:26:28 -0500 Date: Wed, 22 Nov 2023 14:26:28 -0500 From: Bruce Momjian To: Alvaro Herrera Cc: Laurenz Albe , juha.mustonen@iki.fi, pgsql-docs@postgresql.org Subject: Re: [DOCS] Add example about date ISO format Message-ID: References: <39ac320937098e42241b947ec1165ae2003bc478.camel@cybertec.at> <202311221726.xyy54yv2rp52@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202311221726.xyy54yv2rp52@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Nov 22, 2023 at 06:26:45PM +0100, Álvaro Herrera wrote: > On 2023-Nov-22, Laurenz Albe wrote: > > > I think the example had best be at "8.5.2. Date/Time Output", in > > doc/src/sgml/datatype.sgml around line 2552. > > Actually, isn't that a strange location? Chapter 8.5.2 is about the > datatype itself, and there's already a cross-link to Section 9.8 for > to_char() stuff. Since this is to_char() that the example wants to add, > I think the to_char reference is a more appropriate place -- probably > table "9.31 to_char Examples". I originally thought it belonged in section 9.8 too, but I think the value of this example is ISO 8601 and I don't see how we can cleanly mention that in table 9.31. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.