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 1vKk9E-006uZD-2l for pgsql-general@arkaria.postgresql.org; Sun, 16 Nov 2025 21:18:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vKk9C-00BHCw-1w for pgsql-general@arkaria.postgresql.org; Sun, 16 Nov 2025 21:18:58 +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 1vKk9C-00BHCo-0X for pgsql-general@lists.postgresql.org; Sun, 16 Nov 2025 21:18:58 +0000 Received: from mail-lf1-x12d.google.com ([2a00:1450:4864:20::12d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vKk99-0085ek-1g for pgsql-general@postgresql.org; Sun, 16 Nov 2025 21:18:57 +0000 Received: by mail-lf1-x12d.google.com with SMTP id 2adb3069b0e04-5957db5bdedso3333825e87.2 for ; Sun, 16 Nov 2025 13:18:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763327934; x=1763932734; darn=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=wtN+kQ5bC6LGjQHa26d0XAX+43BMuLAR4j7UIqBy8rE=; b=aM48P7DlfJDKPEnHlnjxgPz0QwojvRUHDIk7bRClZd9xgIl8VjE6mBbqDUKV/GlNAa vQq4y4VsJoBSrbq0vQxkO4wa+CGTynPLNjtS5/cu8xE5c5FWzp9r9bjCMQa08Z4cmpy+ pI1bboVPks3iTaQTSlsQprv2mqILggRYe9t4dKcO6+3BPd1fxKdPNcZ5yLo7QzQz5fcI mY33vrbhs1HwPAm683g9qbiKkOb/RO0Q2fYBJZHb+lGJj7Uc5miOStgkfwkOThthqqmN OzU18Pb3y5dFIky9KNIRjDLpUJWL0RVMaB3y6G7Jih4+sMe7XRhKPgmxAuTw/uzkU5rl ZiKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763327934; x=1763932734; 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=wtN+kQ5bC6LGjQHa26d0XAX+43BMuLAR4j7UIqBy8rE=; b=oMsNmZ05tD42AW84tdeL+fDGW2eMSmCp9jS3bx/DpJmfqdU+mutNGnkT29e8JmWZ0M zbrapUhNC49QMHPCUeIdz2MU6PPyR/il6DM7R/AGRkb0EBj5OT1tHI4da3Dwm011sA2t 5D3YZqaSWRLe5G0D5c+vQx3eywxOfJy3R60NW/bSoLsP2auC+8MwCJGyEy/QBQ0tER9Y hRREpg3LNioOJPxq7JeVsbZ7O4VPXKijJ/foPZQohZwpVqyFrlEv2tJe75DvvgQoTvrn U6nJAa27z4ZKaVhPzGDcvuH26w75PHcEcW8DkBuuynzkD0O+txqAeqUiXGN2bxMuaSgA pIIw== X-Gm-Message-State: AOJu0YwbbXOAozR6QuJuiwbEm/hgd2AiD9jKfzZsvdSaJPO8lpGSd3ZJ REdz7cFCGH30BjKVD+nH9rh85JFsJXEbL6ds4JMpzZGt3WPl8c3QRrF1H7+mcueTkHYanV3BK8O Ers8HUcMmo2O0x28lpEd/VgiMKBP2r1w= X-Gm-Gg: ASbGnctkmqEPB/J5zrjS0MvkCu5t5WgMwnvSAWtyCAlEK1lYvrVKarlHdH5MfqMk2jS W+/y77PEmKjfIltpeMNckB2GIYdIS4TT8Gpyz2hbFWuWI4jLzlmoxBeq/qm0v6G7Ija8BulFiL4 32L2MId20ozwMZvABwj1Ln/11NpEIuf8CEjPR1gqYhSlPJLgL+FSFj1r9kBXe39UYbX2CtwAB10 LTHLFuqnRZPYu5fC67soFR/YKkROGMk8IT+9ceq24M55AUjWwcRWwwH/yDqJjGzcFOLfJX+lwrS zZywG2bKoRa/ih6P4AnfbeSTR13HjEZdfD28EzK1vU/8s+IQbRk= X-Google-Smtp-Source: AGHT+IF+Ccgi+wynw2ymrOR/4CWfmMVV5k591wXwO0h7yvC3WsJhpbeDxWb3ZbBRUIjWr1oIZ+wDj+9ZDAeHEXWEs0E= X-Received: by 2002:a05:6512:b8a:b0:595:83c6:222a with SMTP id 2adb3069b0e04-59584141f97mr3481055e87.0.1763327934183; Sun, 16 Nov 2025 13:18:54 -0800 (PST) MIME-Version: 1.0 References: <145c7185c29456e42a9325fe1df63222@posteo.net> In-Reply-To: <145c7185c29456e42a9325fe1df63222@posteo.net> From: David Rowley Date: Mon, 17 Nov 2025 10:18:41 +1300 X-Gm-Features: AWmQ_bkUOFaefNMAReeoaulPMxK0pS0u3dl_R56E6JvU3o9wx2xn2wIb6N0MG9U Message-ID: Subject: Re: RFC 9557 / IXDTF To: pgmis@posteo.net Cc: pgsql-general@postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 17 Nov 2025 at 08:44, wrote: > If not, is there some suggestion on how to best store information like > this? You could just store the time zone name separately, e.g: create table ts (ts timestamptz, tz text); insert into ts values(now(), 'America/Los_Angeles'); select ts at time zone tz from ts; timezone ---------------------------- 2025-11-16 13:18:14.075491 David