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 on psql side like this:
UPDATE files SET date="2007-10-10 10:50:22" WHERE id IN (SELECT unnest (
string_to_array('16767,16766' , ',')::bigint[]))
How can I achieve this with Sequel?
Thanks,
Gencer.
--
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 https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
