Jeremy, what do you mean by "unbounded ranges are not supported by Ruby"?
Because you can create these objects, and still obtain the #begin/#end
information. It would be cool if Sequel could detect a Ruby infinity and
make an unbounded range on that end, would that be doable?
On Tuesday, June 16, 2015 at 5:29:33 PM UTC+2, Jeremy Evans wrote:
>
> On Tuesday, June 16, 2015 at 6:25:57 AM UTC-7, Andrew Burleson wrote:
>>
>> Jeremy,
>>
>> Following up on your suggestion to me in a different thread (I wanted
>> this question to have a better title for searching), I've been exploring
>> the pg_range extension and working on using tsrange.
>>
>> One issue: given a schema like this:
>>
>> create_table :order_states do
>> primary_key :id
>> column :timeframe, :tsrange, :index=>{:type=>:gist}
>> end
>>
>> If I want to create a range that goes from now to the indefinite future,
>> it looks like Postgres wants an insert value like:
>>
>> [today, ‘infinity’)
>>
>> So, in Ruby I tried:
>>
>> os = OrderState.create(timeframe: (Date.today..Float::INFINITY))
>>
>> This fails with
>>
>> Sequel::InvalidValue: ArgumentError: no time information in "infinity"
>>
>> Also, I managed to write a record once with SQL strings, but when I try
>> to load that record I get the same error.
>>
>> So, what is the correct technique for doing using +/- infinity in
>> pg_ranges? I've googled a bunch and not been able to find docs for this.
>>
>
> Unbounded ranges are not supported by ruby, so you can't use ruby ranges
> to represent them. You have to create the PGRange object manually:
>
> Sequel::Postgres::PGRange.new(Date.today, nil)
>
> As you can see here, you can use nil instead of some infinity object,
> since nil specifies no bound, and unbounded ranges are infinite ranges (
> http://www.postgresql.org/docs/9.4/static/rangetypes.html).
>
> Thanks,
> Jeremy
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
