Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] filter records by substring match of an postgresqlarray column - Mailing list pgsql-general

From Jeff Janes
Subject Re: [GENERAL] filter records by substring match of an postgresqlarray column
Date
Msg-id CAMkU=1ztHUY9HgXwyWRk=0rtyf_HkY9sGMROO3h0T-EaSq1n_g@mail.gmail.com
Whole thread Raw
In response to [GENERAL] filter records by substring match of an postgresql array column  (Arup Rakshit <aruprakshit1987@outlook.com>)
List pgsql-general
Tree view


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

pgsql-general by date:

Previous
From: Arup Rakshit
Date:
Subject: [GENERAL] filter records by substring match of an postgresql array column
Next
From: Arup Rakshit
Date:
Subject: Re: [GENERAL] filter records by substring match of an postgresql array column