MIME-Version: 1.0
References: 
 <CAPqRbE716D3gpD0JDbaFAb72ELaJrPpG1LUZvobELNBgL3R0+g@mail.gmail.com>
 <CAOMoQbRMo5HM4eMsUmcQ+5_eGUZK6zycMgifnEehbooee+L5HA@mail.gmail.com>
 <CAOMoQbQPOs827ZNk2atm0JHQYDJ4iW339a8HxovxUZzpa4RjtA@mail.gmail.com>
 <CAPqRbE7W2ifWkjAGZ36cAE1kd23m0gmz5sgn_49MWam2kA+=CQ@mail.gmail.com>
 <75679669-4482-3f16-bd4d-6ec1f9950941@abcsql.com>
 <CAPqRbE4QXeno00wdRU6dy8h9AFr8z1o1keSpxN6=T8eW8jCM_A@mail.gmail.com>
In-Reply-To: 
 <CAPqRbE4QXeno00wdRU6dy8h9AFr8z1o1keSpxN6=T8eW8jCM_A@mail.gmail.com>
From: Bradford Boyle <bradford.d.boyle@gmail.com>
Date: Wed, 7 Jun 2023 18:02:15 -0700
Message-ID: 
 <CAOMoQbTCo1_+0A07qROHqdifiCnev8iAZmbVvJt4omvO7SdG4w@mail.gmail.com>
Subject: Re: Packaging request MobilityDB
To: Esteban Zimanyi <estebanzimanyi@gmail.com>
Cc: =?UTF-8?Q?C=C3=A9dric_Villemain?= <cedric.villemain@abcsql.com>,
	pgsql-pkg-debian@lists.postgresql.org,
	SCHOEMANS Maxime <Maxime.Schoemans@ulb.be>
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOMoQbTCo1_%2B0A07qROHqdifiCnev8iAZmbVvJt4omvO7SdG4w%40mail.gmail.com>
Precedence: bulk

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