Bo Jeanes@bjeanes·Dec 8, 2016In Postgres, is it possible to check if a smaller array is contained within a larger array, factoring in order without gaps?2
Bo Jeanes@bjeanes·Dec 8, 2016Replying to @bjeanesi.e. '{1,2,3,4,5}' @?> '{1,3,5}' == false, '{1,3,5,7}' @?> '{1,3,5}' == true?1
Peter Geoghegan@petervgeogheganReplying to @bjeanesI'd probably use unnest() if indexing isn't an issue.1:10 AM · Dec 8, 2016·Twitter Web Client
Bo Jeanes@bjeanes·Dec 8, 2016Replying to @petervgeogheganyeah that makes sense but I think I've found another approach... Maybe