Re: Domain based on TIMEZONE WITH TIME ZONE
| От | Ben Hood |
|---|---|
| Тема | Re: Domain based on TIMEZONE WITH TIME ZONE |
| Дата | |
| Msg-id | D9289E35-E24B-4C3A-8E76-18220DF01719@relops.com обсуждение исходный текст |
| Ответ на | Re: Domain based on TIMEZONE WITH TIME ZONE (Vick Khera <vivek@khera.org>) |
| Ответы |
Re: Domain based on TIMEZONE WITH TIME ZONE
Re: Domain based on TIMEZONE WITH TIME ZONE |
| Список | pgsql-general |
On 10 May 2018, at 15:12, Vick Khera <vivek@khera.org> wrote:On Thu, May 10, 2018 at 7:31 AM, Ben Hood <ben@relops.com> wrote:Or are we saying that domains are one way of achieving the timestamp hygiene, but equally, you can get the same result as described above?The *only* way to have timestamp hygiene is to require them to have time zones at all times, even if that time zone is UTC. Any other representation of a time is ambiguous without context.
That makes sense.
The motivation behind narrowing the built in TIMESTAMP WITH TIME ZONE down to a domain is to ensure the only permissible zone offset is UTC. This would be unambiguous.
В списке pgsql-general по дате отправления: