pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Vik Fearing <vik@postgresfriends.org>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Add support for AT LOCAL
Date: Tue, 06 Jun 2023 19:02:26 +0200
Message-ID: <880dec75f1d509233a3935ef80d80f282b1ef136.camel@cybertec.at> (raw)
In-Reply-To: <ef0aa5f1-8ea6-088c-3a3a-5804c12f79b1@postgresfriends.org>
References: <8e25dec4-5667-c1a5-6581-167d710c2182@postgresfriends.org>
	<9ff5cddd07372817ec7894202214804d46cd6176.camel@cybertec.at>
	<ef0aa5f1-8ea6-088c-3a3a-5804c12f79b1@postgresfriends.org>

On Tue, 2023-06-06 at 04:24 -0400, Vik Fearing wrote:
> > At a quick glance, it looks like you resolve "timezone" at the time
> > the query is parsed.  Shouldn't the resolution happen at query
> > execution time?
> 
> current_setting(text) is stable, and my tests show that it is calculated 
> at execution time.

Ah, ok, then sorry for the noise.  I misread the code then.

Yours,
Laurenz Albe





view thread (60+ messages)  latest in thread

Message-ID: <880dec75f1d509233a3935ef80d80f282b1ef136.camel@cybertec.at>
Permalink:  ../880dec75f1d509233a3935ef80d80f282b1ef136.camel@cybertec.at/
Also on:    postgresql.org/message-id/880dec75f1d509233a3935ef80d80f282b1ef136.camel@cybertec.at

 · 

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: pgsql-hackers@postgresql.org
  Cc: laurenz.albe@cybertec.at, vik@postgresfriends.org, pgsql-hackers@lists.postgresql.org
  Subject: Re: Add support for AT LOCAL
  In-Reply-To: <880dec75f1d509233a3935ef80d80f282b1ef136.camel@cybertec.at>

* 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