BUG #17473: Custom range type with timestamp doesn't respect precision

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: cwikla(at)puzzle(dot)io
Subject: BUG #17473: Custom range type with timestamp doesn't respect precision
Date: 2022-04-29 19:19:27
Message-ID: 17473-0b8caedccc6ee7b1@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17473
Logged by: John Cwikla
Email address: cwikla(at)puzzle(dot)io
PostgreSQL version: 14.2
Operating system: Debian 14.2-1.pgdg110+1
Description:

Are range types supposed to respect precision? There is no mention of
precision in the documents that I can find, and it doesn't seem to be the
case for timestamps.

psql (14.2 (Debian 14.2-1.pgdg110+1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits:
256, compression: off)
Type "help" for help.

postgres=> CREATE TYPE tstzrange3 AS RANGE ( subtype = timestamp(3) with
time zone);
CREATE TYPE
postgres=> select tstzrange3(NOW(), NULL);
tstzrange3
------------------------------------
["2022-04-29 19:11:31.920322+00",)
(1 row)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2022-04-29 21:20:24 Re: BUG #17473: Custom range type with timestamp doesn't respect precision
Previous Message Joe Hebert (jhebert) 2022-04-29 17:34:44 RE: [EXT] Re: BUG #17469: postgresql-11.service file not configured to match setup/initdb options specified