public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bradford Boyle <[email protected]>
To: Esteban Zimanyi <[email protected]>
Cc: Cédric Villemain <[email protected]>
Cc: [email protected]
Cc: SCHOEMANS Maxime <[email protected]>
Subject: Re: Packaging request MobilityDB
Date: Wed, 7 Jun 2023 18:02:15 -0700
Message-ID: <CAOMoQbTCo1_+0A07qROHqdifiCnev8iAZmbVvJt4omvO7SdG4w@mail.gmail.com> (raw)
In-Reply-To: <CAPqRbE4QXeno00wdRU6dy8h9AFr8z1o1keSpxN6=T8eW8jCM_A@mail.gmail.com>
References: <CAPqRbE716D3gpD0JDbaFAb72ELaJrPpG1LUZvobELNBgL3R0+g@mail.gmail.com>
<CAOMoQbRMo5HM4eMsUmcQ+5_eGUZK6zycMgifnEehbooee+L5HA@mail.gmail.com>
<CAOMoQbQPOs827ZNk2atm0JHQYDJ4iW339a8HxovxUZzpa4RjtA@mail.gmail.com>
<CAPqRbE7W2ifWkjAGZ36cAE1kd23m0gmz5sgn_49MWam2kA+=CQ@mail.gmail.com>
<[email protected]>
<CAPqRbE4QXeno00wdRU6dy8h9AFr8z1o1keSpxN6=T8eW8jCM_A@mail.gmail.com>
I suspect this may be an actual bug. I tested develop (07fafdf1) on both
macOS and Debian. On macOS, changing the timezone is reflected in the
output but not the datestyle. On Debian, changes to timezone and
datestyle are reflected in the output.
On macOS
```sql
SET timezone TO 'Europe/Berlin';
SET datestyle TO 'German';
SELECT now();
-- now
-- ---------------------------------
-- 08.06.2023 02:45:35.214256 CEST
-- (1 row)
-- SELECT set(ARRAY [timestamptz '2000-01-01', '2000-01-02', '2000-01-03']);
-- set
-- --------------------------------------------------------------------------------
-- {"2000-01-01 00:00:00+01", "2000-01-02 00:00:00+01", "2000-01-03
00:00:00+01"}
-- (1 row)
```
On Debian Bookworm
```sql
SET timezone TO 'Europe/Berlin';
SET datestyle TO 'German';
SELECT now();
-- now
-- ---------------------------------
-- 08.06.2023 02:53:11.748104 CEST
-- (1 row)
SELECT set(ARRAY [timestamptz '2000-01-01', '2000-01-02', '2000-01-03']);
-- set
-- -----------------------------------------------------------------------------------
-- {"01.01.2000 00:00:00 CET", "02.01.2000 00:00:00 CET", "03.01.2000
00:00:00 CET"}
-- (1 row)
```
--Bradford
view thread (18+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Packaging request MobilityDB
In-Reply-To: <CAOMoQbTCo1_+0A07qROHqdifiCnev8iAZmbVvJt4omvO7SdG4w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox