Re: Prepared statements and INSERT INTO ... SELECT statements

That worked perfectly! Thank you! On Friday, April 6, 2018 at 4:22:57 PM UTC-5, Jeremy Evans wrote: > > On Friday, April 6, 2018 at 1:44:55 PM UTC-7, Ransom Briggs wrote: >> >> Hello, >> >> I have an insert statement that is inserting values selected from another

Adding Set as a SQL literal

I have a query where I do some pre processing with a Set to eliminate duplicates and am converting to an array to avoid this error. *** Sequel::Error Exception: can't express # as a SQL literal I peeked at the code and adding it as a supported type did not look too hard. If I put together a

Prepared statements and INSERT INTO ... SELECT statements

Hello, I have an insert statement that is inserting values selected from another table based on some filters. I am trying to convert this to a prepared statement, but from what I can tell, the prepared statement version of insert

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

_at On Tue, Jul 5, 2016 at 6:01 PM, Jeremy Evans <jeremyeva...@gmail.com> wrote: > 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 exclu

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

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