From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Alban Hertroijs <a.hertroijs@nieuwestroom.nl>
To: Karsten Hilbert <Karsten.Hilbert@gmx.net>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Time zone offset in to_char()
Date: Thu, 11 Jan 2024 09:27:37 -0800
Message-ID: <5fb4d1a8-0597-4f87-9a6b-db1a99b0ebfe@aklaver.com> (raw)
In-Reply-To: <37804bda-ebe5-4786-be63-4d2a325368a6@aklaver.com>
References: <DB8P189MB1046C0D82500690791CED07AE2682@DB8P189MB1046.EURP189.PROD.OUTLOOK.COM>
<trinity-d7c2c180-6711-4cd5-86a0-60c7dad52e88-1704985919018@3c-app-gmx-bs12>
<DB8P189MB104657B99989D8F61C5BE2C9E2682@DB8P189MB1046.EURP189.PROD.OUTLOOK.COM>
<37804bda-ebe5-4786-be63-4d2a325368a6@aklaver.com>
On 1/11/24 08:48, Adrian Klaver wrote:
> On 1/11/24 08:04, Alban Hertroijs wrote:
>> The drawback, as mentioned, being that we need to maintain those
>> functions in each deployment, which is a bit of a hassle (albeit a
>> minor one) because we need to customise both the TDV side and the
>> PostgreSQL side in that case. Our preferred solution would be to just
>> add a few entries to the TDV database-specific capabilities file (as
>> described in my initial message)
>
> Are you referring to?:
>
> "It currently have this:
> ToDatetimeOffsetNL(~any) : ciscache.ToDatetimeOffsetNL($1)
> ToDatetimeOffset(~any,~any) : ciscache.ToDatetimeOffset($1, $2)
> "
It finally dawned on me, you want to replace the user defined functions
above with Postgres builtins only. Try as I might I could not come with
that solution.
>
> I thought the issue there was maintaining the two Postgres functions?
>
>
>> Provided that such a solution is possible, that is. If not, my current
>> approach may have to suffice.
>>
>> The reason I decided to ask on the ML is that I'm finding it hard to
>> believe that this transformation would be this difficult, so I expect
>> that I must be missing something.
>>
>> Regards,
>> Alban Hertroys
>
--
Adrian Klaver
adrian.klaver@aklaver.com
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: adrian.klaver@aklaver.com, a.hertroijs@nieuwestroom.nl, Karsten.Hilbert@gmx.net
Subject: Re: Time zone offset in to_char()
In-Reply-To: <5fb4d1a8-0597-4f87-9a6b-db1a99b0ebfe@aklaver.com>
References: <DB8P189MB1046C0D82500690791CED07AE2682@DB8P189MB1046.EURP189.PROD.OUTLOOK.COM> <trinity-d7c2c180-6711-4cd5-86a0-60c7dad52e88-1704985919018@3c-app-gmx-bs12> <DB8P189MB104657B99989D8F61C5BE2C9E2682@DB8P189MB1046.EURP189.PROD.OUTLOOK.COM> <37804bda-ebe5-4786-be63-4d2a325368a6@aklaver.com> <5fb4d1a8-0597-4f87-9a6b-db1a99b0ebfe@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox