Re: Should AT TIME ZONE be volatile? - Mailing list pgsql-hackers

From Shay Rojansky
Subject Re: Should AT TIME ZONE be volatile?
Date
Msg-id CADT4RqDvg-juSfRW0sfYbsP-nxxwhQWD01LHH76_V=xw-xNxEA@mail.gmail.com
Whole thread Raw
In response to Re: Should AT TIME ZONE be volatile?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] Partial foreign key updates in referential integrity triggers
Next
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: [BUG]Invalidate relcache when setting REPLICA IDENTITY