Range Types - symmetric

Поиск
Список
Период
Сортировка
От Erik Rijkers
Тема Range Types - symmetric
Дата
Msg-id 8eece6ec9500b1d4382f06f07dcedd7f.squirrel@webmail.xs4all.nl
обсуждение исходный текст
Ответы Re: Range Types - symmetric
Список pgsql-hackers
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
Дата:
Сообщение: Re: unite recovery.conf and postgresql.conf