Re: How do I represent the a greater than comparison in insert_conflict with update_where?

2016-07-06 Thread Ransom Briggs
Thanks! That worked wonderfully, what it ended up being in the end was the following. I had the comparison operator flipped in my because excluded should win if it is later in time. Also had to prefix :cached_at with the table name. Sequel.expr(:name_cache__cached_at) <= :excluded__cached_at

Re: How do I represent the a greater than comparison in insert_conflict with update_where?

2016-07-05 Thread Jeremy Evans
On Tuesday, July 5, 2016 at 3:54:15 PM UTC-7, Ransom Briggs wrote: > > I am having issues trying to figure out how to do an insert_conflict query > with a comparison with an excluded column in the update_where parameter. > > Here is a simplified version of my table, which is basically just

How do I represent the a greater than comparison in insert_conflict with update_where?

2016-07-05 Thread Ransom Briggs
I am having issues trying to figure out how to do an insert_conflict query with a comparison with an excluded column in the update_where parameter. Here is a simplified version of my table, which is basically just serving as a cache for an external data source. I have multiple writers so there