On Nov 8, 2017 02:34, "Arup Rakshit" <aruprakshit1987@xxxxxxxxxxx> 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
