pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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






view thread (21+ messages)  latest in thread

Message-ID: <5fb4d1a8-0597-4f87-9a6b-db1a99b0ebfe@aklaver.com>
Permalink:  ../5fb4d1a8-0597-4f87-9a6b-db1a99b0ebfe@aklaver.com/
Also on:    postgresql.org/message-id/5fb4d1a8-0597-4f87-9a6b-db1a99b0ebfe@aklaver.com

 · 

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 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