Re: 9.2 Range Types

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Dave Bettin <me(at)davebettin(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 9.2 Range Types
Date: 2012-05-30 19:02:40
Message-ID: CAHyXU0x0mzv8x_FRavBft-Z66qer9Z5+uFMGc3kvh0JpwYY1eg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 30, 2012 at 1:59 PM, Dave Bettin <me(at)davebettin(dot)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.

yup:

postgres=# select array['[0,5999)'::int4range];
array
--------------
{"[0,5999)"}
(1 row)

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Shott 2012-05-30 19:18:40 Re: Postgres no longer starts
Previous Message Dave Bettin 2012-05-30 18:59:31 9.2 Range Types