On Nov 8, 2017 02:34, "Arup Rakshit" <aruprakshit1...@outlook.com> wrote:
Hi, I do have a videos table, and it has a column called `tags` of type array. I would like to select all videos where any string inside tag column matches a given substring. What method should I use? The *Contains `@>` operator* will do full string comparisons as far as I understood. The extension parray_gin ( https://pgxn.org/dist/parray_gin/doc/parray_gin.html) offers the @@> operator. Cheers, Jeff
