Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCVQe-0008U2-He for pgsql-docs@arkaria.postgresql.org; Fri, 23 Jun 2023 01:17:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qCVQc-0002m3-Ax for pgsql-docs@arkaria.postgresql.org; Fri, 23 Jun 2023 01:17:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCVQc-0002lu-3s for pgsql-docs@lists.postgresql.org; Fri, 23 Jun 2023 01:17:34 +0000 Received: from mout-u-107.mailbox.org ([2001:67c:2050:101:465::107]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qCVQZ-0047Km-Du for pgsql-docs@lists.postgresql.org; Fri, 23 Jun 2023 01:17:33 +0000 Received: from smtp102.mailbox.org (smtp102.mailbox.org [10.196.197.102]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-107.mailbox.org (Postfix) with ESMTPS id 4QnK931ksgz9sPx; Fri, 23 Jun 2023 03:17:27 +0200 (CEST) Date: Fri, 23 Jun 2023 03:17:26 +0200 (CEST) From: Erik Wienhold To: Bruce Momjian , Kirk Parker Cc: pbaumard@gmail.com, pgsql-docs@lists.postgresql.org Message-ID: <221510448.1356631.1687483046344@office.mailbox.org> In-Reply-To: References: <168724660637.399156.7642965215720120947@wrigleys.postgresql.org> Subject: Re: Change "two" to "three" for decades of development in history MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Normal List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 22/06/2023 23:00 CEST Bruce Momjian wrote: > > On Thu, Jun 22, 2023 at 01:47:16PM -0700, Kirk Parker wrote: > > > > I don't suppose DocBook has macro and system-variable capabilities? That > > could provide a set-and-forget solution to this? > > Uh, I am not aware of any. An SGML entity [0] or an xsltproc stringparam [1] looks viable. Question is how to calculate the number of decades in the Makefile. It's trivial in SQL :) =# select extract(decade from now()) - extract(decade from date '1986-01-01'); ?column? ---------- 4 (1 row) =# select extract(day from now() - date '1986-01-01') / 365.25 / 10; ?column? -------------------- 3.7472963723477071 (1 row) [0] https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=doc/src/sgml/Makefile;h=71cbef230f34a6ad6b41a667c7d2977fb6560378;hb=HEAD#l98 [1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=doc/src/sgml/Makefile;h=71cbef230f34a6ad6b41a667c7d2977fb6560378;hb=HEAD#l56 -- Erik