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.96) (envelope-from ) id 1wIS02-0086v6-0p for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Apr 2026 14:04:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wIS01-007kx5-1e for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Apr 2026 14:04:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wIS01-007kwx-0s for pgsql-bugs@lists.postgresql.org; Thu, 30 Apr 2026 14:04:17 +0000 Received: from mail-yw1-x1135.google.com ([2607:f8b0:4864:20::1135]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wIRzz-000000040dj-0sVC for pgsql-bugs@lists.postgresql.org; Thu, 30 Apr 2026 14:04:16 +0000 Received: by mail-yw1-x1135.google.com with SMTP id 00721157ae682-79db5e18ac6so25930527b3.1 for ; Thu, 30 Apr 2026 07:04:14 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777557853; cv=none; d=google.com; s=arc-20240605; b=OmZhTbzsRpMXfp+elhyjbSVRGssKFyS1QlJjbkWoVUI7xYF5fJUil0HtZzOEGaZY6/ WLgo2uev16dHLyw4e8nkvHQs+61NGLtm8U0dSKiOAGih8GG5nRHVlRo4guWCslveTOUA faVJTiKnF3M8QimiUfEp+0agDYBKcAM5YWAL4OEWojmhcDmt1j+uFIOmXJfuayNEg+Dd 2iLwgmVVb2xZJXCz0YHm6BzThJLihZh2SUiJoGsGbZIeXYaNnNG0NANyTmZ9siqEMdH6 j4F98JruuMRfI2XT0sNcuzj6szR2Br7Lv9Yq6xIJ6fxSj0HC8xBjbsFvNbk8FXnx53eg CSLw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=Z0XXBRM+iT3rSoQ3Vcp7iDHVDrnBiGb1GLbABbxQR4g=; fh=KOu59wqflo0hnUeJPLYHsgsuwm7QoFbZRI4c6g+Tyow=; b=To4XwySugNOxZPmBDfdOTy7Ieff3mi326ZB+T0oSXnwMCzPcovnMOqW/03CGjavx/s Iac89yD5MwTdmXyKAJWtEy6RP7lBBFlUNfITzhxxE+Pn9Uk/frxca9KCX2dR97IQSNN7 CFTWYZWQm3fjFa8nvKCE3oDmJTL4g1oIV/7td4iloP0hQ/CvxnIYVFIGERa5znD7s10w JwDwfxiRALY1JpEu8mGto+v3PG7oXfrav/cBT5sVXr2t7r1iyhaAT/0xscrAX32Fkuhr kpmFUHJWXgmQ/TFYBdTQG1DEkva2UWYij6FPJ0TZ7HHASI7v/itt6H3w8b6iOzu6QNOD LfPw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777557853; x=1778162653; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Z0XXBRM+iT3rSoQ3Vcp7iDHVDrnBiGb1GLbABbxQR4g=; b=DTeM/26bqAaPu2/XQWONPEbruO6cg8J/Boa0wjsbLLQCUcOA+jOjyEOIoKUVVmur4U Nt6xFkTupWMvv9mLoe0F95KPX9DXPyxFvkjpIMCVNv7gc84cMFZmsoQBNY/ruVq+70K6 dKUX3xV6Ibe5LMJ7JWojzacaXXh6AuwBfS1jYgLNI8hysAF2yFcP3NlDzErDc1Wh8zTK tJQNStwYzfrSGjp7tN7Z/+xFRK+ViPBVi9kBUAxeHvwhkhvAZTAG59+XbhA7pRmpMFls D5VMhgjWLu65b3v8wyz7wChzQprvSEInZvyNxI0vPkfjQetI7RiVwGAD2T8NhbJ2LS9v wJ6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777557853; x=1778162653; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Z0XXBRM+iT3rSoQ3Vcp7iDHVDrnBiGb1GLbABbxQR4g=; b=P0/K9UWQBcqdEQhcW8FJjV6QJpMmR+GJID47ob7U0GkzxHVbcuhjzQ7noWwM9N5mNW aWLBQ+MZfBxZEsDweZhPW0qTA80iu1Gd8C/2jx+883gMC9+zPSGFoAVqXusPn4zLMIiG JFYMvxKbr0KZOjYaSRvbOmUNDnvqu3rfZXGJGv/sn2wNWpnX6cHS3g3hQqZMQoy23KCB lUY3FKMSwmvSlbTt80eYqNcj5vXF1Xs9bvnKZLq7X/pfD6QslP7XYSFdUx7d6WdTrNcB 5p+RAepktBqPsBA+fZDw+bmRh3d+tm1cGCEvr8vFltRuxXHzEyyhpNU/22y+AHvPpb85 M2Bg== X-Gm-Message-State: AOJu0Yxbb0R9YD3fjFaTqlUeQjznB4FnNjoVTbHNKV89e25FgJ3GibYv MLaiRbN7Zvc1VKg5CBa8fXm9l6RZryP96BfrII/SWkP9MCqWCemUoSOuf0yumcI/uELP8wskTkV mDQQ1vU082hPp9cmTJbXgo/9l8pXBk8I= X-Gm-Gg: AeBDietiVXDkbw+mpP+4DmLDeQz2WliMyBx1ggAX93Cvueaj0o1Xf2J1aAWMhvjrqS/ IHvC72mnZIHVbuDXoMYsPFqDikHMxGHmW2XogI+McLifRX0yCGpaWtFjREMrSCmUT5C/cZAzuTh 4JfCHebd6ffL95yk05lTiaHnXZNIRKrLZIBAH1lJCaBz78Q6lTA/H4XHKk69CkdthBbdfj+g9rC XPw2nNVDrHfnOZ6Xs2UzZwhe5LYVzIt1SVkExdzyC9fMUjMXf6k9a56wUYTRcSDFSs9Pl7g51UY cLob+dKznnQgnEFMfUlE/FK8sGE1 X-Received: by 2002:a05:690e:2502:20b0:651:e1e7:7f51 with SMTP id 956f58d0204a3-65c1b0a49d2mr1352030d50.31.1777557852790; Thu, 30 Apr 2026 07:04:12 -0700 (PDT) MIME-Version: 1.0 References: <9A86E1BE-C32F-4548-947C-C292A65DEBC2@onedb.online> In-Reply-To: <9A86E1BE-C32F-4548-947C-C292A65DEBC2@onedb.online> From: "David G. Johnston" Date: Thu, 30 Apr 2026 07:03:34 -0700 X-Gm-Features: AVHnY4LEL2-pmDjArNXpKqLEfShm_qw7ieq8mLKt3jS9wu-G-r6RpbSzrNkNDjw Message-ID: Subject: Re: Interval unit format bug To: Gary Clarke Cc: "pgsql-bugs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000006224f10650adf006" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006224f10650adf006 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Apr 30, 2026 at 6:32=E2=80=AFAM Gary Clarke wro= te: > > Even if I set to verbose, Postgres outputs a very strange abbreviation fo= r > interval unit months that nobody else uses or would expect. > > > Suggest you use the SQL or ISO variant format then. We aren't going to change what we produce and risk breaking people's stuff. David J. --0000000000006224f10650adf006 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Apr 30, 2026 at 6:32=E2=80=AFAM Gary Clarke <ga= ry@onedb.online> wrote:


Even if I set to verb= ose, Postgres outputs a very strange abbreviation for interval unit months = that nobody else uses or would expect.

=C2=A0


Suggest you use the= SQL or ISO variant format then.=C2=A0 We aren't going to change what w= e produce and risk breaking people's stuff.

David = J.

--0000000000006224f10650adf006--