Re: How to use Where IN "string_to_array" with Sequel?

2019-02-01 Thread Jeremy Evans
On Friday, February 1, 2019 at 6:54:59 AM UTC-8, genc wrote: > > Hi Jeremy, > > On PostgreSQL there is a string_to_array function. This is currently What > I am doing: > > UPDATE files SET date="2007-10-10 10:50:22" WHERE id in(1,2,3,4,5..) > > > However, IDs can be very large and can be

How to use Where IN "string_to_array" with Sequel?

2019-02-01 Thread genc
Hi Jeremy, On PostgreSQL there is a string_to_array function. This is currently What I am doing: UPDATE files SET date="2007-10-10 10:50:22" WHERE id in(1,2,3,4,5..) However, IDs can be very large and can be oversize for a query. Due to this I woulşd like to send them as text and split