Re: RangeType internal use

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: RangeType internal use
Дата
Msg-id 26028.1423235431@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RangeType internal use  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Ответы Re: RangeType internal use
Список pgsql-hackers
Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> writes:
> I wonder why I cannot find a way to get a range type for a given (sub-)
> type. I would like to build a RangeType from Datum's of lower and upper
> bounds. Much like how construct_array() builds an ArrayType from a Datum
> array of elements given elements' type info.

> Is there some way I do not seem to know? If not, would it be worthwhile
> to make something like construct_range() that returns a RangeType given
> Datum's of lower and upper bounds and subtype info?

There is no good reason to assume that a range type exists at all, much
less that it is unique for a subtype.  (Read the CREATE TYPE documentation
if you're unclear as to why not.)  You have not said what you're trying to
accomplish, but this seems like a dead end.
        regards, tom lane



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