All about code - Ruby and Rails technical content written by Lucian Ghinda

All about code - Ruby and Rails technical content written by Lucian Ghinda

#sql

Articles tagged with #sql

How to update multiple different values at the same time in one query
How to create a raw SQL to update in Rails different values for each record in one single query
Apr 1, 20223 min read5.4K
Active Record: How to select rows based on the number of items in an array column (PostgreSQL)
Context You have a column in your table that is used as an array , like this: t.string 'ids', array: true And you want to select all records that have more than N elements in the array Solution In PostgreSQL, you can use cardinality to achieve ...
Dec 16, 20211 min read142