EXCLUDE USING and tstzrange

Поиск
Список
Период
Сортировка
От Laura Smith
Тема EXCLUDE USING and tstzrange
Дата
Msg-id _I9_RfNXHYGvv2alXMBSyqodcq0ioZ0C-WpCQYRMZ6l6PEYon4DRt_x95siMaYMt1Gt4XkDe5TkgxIWm5shHc75mpyEA-V466SDX-3vCHuI=@protonmail.ch
обсуждение исходный текст
Ответы Re: EXCLUDE USING and tstzrange
Список pgsql-general
Hi,

I'm having difficulty finding the right part of the docs for this one.

Could someone kindly clarify:

create table test (
test_id text,
test_range tstzrange);

Will "EXCLUDE USING gist (test_id WITH =, test_range WITH && )" work as expected or do I need to use "EXCLUDE USING
gist(test_id WITH =, test_range WITH TIME ZONE && )" to ensure the timezone is correctly taken into account during
comparison? 

Thanks !

Laura



В списке pgsql-general по дате отправления: