Re: 9.2 Range Types

Поиск
Список
Период
Сортировка
От Dave Bettin
Тема Re: 9.2 Range Types
Дата
Msg-id CAByGkiiRyL-8=-J-T=tJQUnZJ48xTJxs0BAe9bUVFfq1u9hYLw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 9.2 Range Types  (David Johnston <polobo@yahoo.com>)
Список pgsql-general
Дерево обсуждения
Awesome, I will give it a try. 

Thanks!

On Wed, May 30, 2012 at 1:00 PM, David Johnston <polobo@yahoo.com> wrote:
In theory...(not running 9.2 that I could test):

{"[0,5999)","[7000,7999)"}::int4range[]

Not sure the exact type name for the int4range.  The double quotes are necessary.  The curly-braces surround the whole array and elements are separated by commas.

David J.

On May 30, 2012, at 14:59, Dave Bettin <me@davebettin.com> wrote:

> Does 9.2 support an array of ranges?  For example, I have the following int4ranges => [0,5999) and [7000, 7999) which needs to be associated with the same record.
>
> Thanks,
> Dave

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Export and import from one postgres server to another
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Usability write-up - looking at Pg, especially PgAdmin-III and Pg on Windows, from an inexperienced user PoV