Re: Should AT TIME ZONE be volatile?

From: Shay Rojansky <roji(at)roji(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Should AT TIME ZONE be volatile?
Date: 2021-11-11 11:05:22
Message-ID: CADT4RqDvg-juSfRW0sfYbsP-nxxwhQWD01LHH76_V=xw-xNxEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Yeah, it's not clear that forbidding this would make anyone's life any
> better. If you want an index on the UTC equivalent of a local time,
> you're going to have to find a way to cope with potential mapping
> changes. But refusing to let you use a generated column doesn't
> seem to help that.

Makes sense, thanks Tom.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message houzj.fnst@fujitsu.com 2021-11-11 12:01:33 RE: [BUG]Invalidate relcache when setting REPLICA IDENTITY
Previous Message Sergei Kornilov 2021-11-11 11:00:56 unexpected plan with id = any('{}') condition