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 1vKk34-006rSe-38 for pgsql-general@arkaria.postgresql.org; Sun, 16 Nov 2025 21:12:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vKk30-00BEIR-1K for pgsql-general@arkaria.postgresql.org; Sun, 16 Nov 2025 21:12:34 +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 1vKk2z-00BEHz-16 for pgsql-general@lists.postgresql.org; Sun, 16 Nov 2025 21:12:34 +0000 Received: from fout-b8-smtp.messagingengine.com ([202.12.124.151]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vKk2t-0085c5-1X for pgsql-general@postgresql.org; Sun, 16 Nov 2025 21:12:32 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.stl.internal (Postfix) with ESMTP id 763C51D0003B; Sun, 16 Nov 2025 16:12:24 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Sun, 16 Nov 2025 16:12:24 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1763327544; x=1763413944; bh=UrPg5/HxSercpsR7A4OLjPq1UUvzEir2pgFHULpvjC4=; b= Pnnm9m5vJ1WJ4TesPyKnnIfW9CgrTe5+Xy5K8nodIw2T4NR9mT9Moj5tCcK98C6s 3l0Kvsv9QO8uLqsvWf0BoD8fEwnu4ecPRZi3BG7EGeNy0IfWt3iLCCwdlXdeJeTE NXkVtQ6qCQXHnWT8E8JxzJ/ELGjYY9/9feSDbSfKw33HnVDuDYuwEng/b1SHkZhO Wg7UDtCgIAHWw/w/DfJaG+tlGzCkV6luVQk1MjKWab7eFhP5ehsXRU/ilrpNrMbo Hpm3ItRk8v+oVDgfkdiIdLWlcky4URbpGxUnVMHqkPCqdxakI2MquX2bSWxKwbL/ NySDGD6QqytFSajp5n6mFA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1763327544; x=1763413944; bh=U rPg5/HxSercpsR7A4OLjPq1UUvzEir2pgFHULpvjC4=; b=lQLpJWrJclc8hHHBV yy/zA+/+p39eZkZ0xUKbqZ97b97vT5RlKM4PM63nvuczo5RAaOB4Hs61CJpFEXTx a7xd1nkiDx4V87Yua+sjj1qGvAETsChyDh4Jr8lMGUyz0EDa8OvSY11HcIpSaCYp irecBQOLmq7rzfrFu86eN4D3ZW3luBUmJFXSox/0o1yvuoyxs0FmCd8dofQqCJrt zONWNW3XOiQOCGboMXF5Bswy0F1Yh2glKWqTofMojetBw5IrNIetykg8yR7Xv8co A+md9moR0mE8qAcsEIemUI9OpgJeUTUsPmpsflyVMNOtfo5vrSyW12KWXbzoZ6d0 dQLYQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddvudeiieefucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucenucfjughrpefkffggfgfuvfhfhfgjtgfgsehtjeertd dtvdejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgr vhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepieeufeffveelte ehgfeugedugfejvedvteeiudfghedtteevfefhhfetjeeuuefgnecuffhomhgrihhnpehi vghtfhdrohhrghdpfihikhhiphgvughirgdrohhrghenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhl rghvvghrrdgtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprh gtphhtthhopehpghhmihhssehpohhsthgvohdrnhgvthdprhgtphhtthhopehpghhsqhhl qdhgvghnvghrrghlsehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 16 Nov 2025 16:12:23 -0500 (EST) Message-ID: <72d49ca8-535e-4ab9-8156-6cdc43d8942b@aklaver.com> Date: Sun, 16 Nov 2025 13:12:23 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: RFC 9557 / IXDTF To: pgmis@posteo.net, pgsql-general@postgresql.org References: <145c7185c29456e42a9325fe1df63222@posteo.net> Content-Language: en-US From: Adrian Klaver In-Reply-To: <145c7185c29456e42a9325fe1df63222@posteo.net> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/16/25 11:43, pgmis@posteo.net wrote: > Hello, > > does postgres consider some sort of implementation of rfc9557 IXDTF? > This is new time internet time format which extends timestamps with > timezone info together with the offset > - https://datatracker.ietf.org/doc/html/rfc9557 > - https://en.wikipedia.org/wiki/RFC_9557#Usage > > If not, is there some suggestion on how to best store information like > this? select '1996-12-19T16:39:57-08:00[America/Los_Angeles]'::timestamp; ERROR: invalid input syntax for type timestamp: "1996-12-19T16:39:57-08:00[America/Los_Angeles]" select '1996-12-19T16:39:57-08:00[America/Los_Angeles]'::timestamptz; ERROR: invalid input syntax for type timestamp with time zone: "1996-12-19T16:39:57-08:00[America/Los_Angeles]" select '1996-12-19T16:39:57-08:00[America/Los_Angeles]'::varchar; varchar ------------------------------------------------ 1996-12-19T16:39:57-08:00[America/Los_Angeles] Your only option at this point would be to store as a string. That means though you lose out on using any of the Postgres datetime operators or functions, unless you do some regex to pull out the timezone portion and then use that with the datetime string to create a timestamp or timestamptz. I could see that being wrapped into a function. > > Thanks, > Miroslav > > -- Adrian Klaver adrian.klaver@aklaver.com