Range Types - symmetric

Поиск
Список
Период
Сортировка
Искать
От
Erik Rijkers
Тема
Range Types - symmetric
Дата
Msg-id
8eece6ec9500b1d4382f06f07dcedd7f.squirrel@webmail.xs4all.nl
Список
Дерево обсуждения
Range Types - symmetric "Erik Rijkers" <er@xs4all.nl>
Re: Range Types - symmetric Christopher Browne <cbbrowne@gmail.com>
Re: Range Types - symmetric Jeff Davis <pgsql@j-davis.com>
Re: Range Types - symmetric Bruce Momjian <bruce@momjian.us>
Re: Range Types - symmetric Jeff Davis <pgsql@j-davis.com>
Re: Range Types - symmetric Joshua Berkus <josh@agliodbs.com>
Hi,

Just a thought:

select int4range(5,2);
ERROR:  range lower bound must be less than or equal to range upper bound

Of course, I won't argue this is a bug, but I was wondering if it wouldn't be handy to allow a
'symmetric' mode in range construction, where, if the first of the pair is higher than the second,
they are automatically swapped, similar to SYMMETRIC in the BETWEEN clause.

Admittedly, I don't have a specific 'use case' -- it might just often prevent 'manual' swapping
before range construction calls.

Thanks,

Erik Rijkers




В списке pgsql-hackers по дате отправления
От: panam
Дата:
Сообщение: Re: fix for pg_upgrade
От: Simon Riggs
Дата:
FAQ