Re: [GENERAL] filter records by substring match of an postgresqlarray column

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [GENERAL] filter records by substring match of an postgresqlarray column
Дата
Msg-id CAMkU=1ztHUY9HgXwyWRk=0rtyf_HkY9sGMROO3h0T-EaSq1n_g@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] filter records by substring match of an postgresql array column  (Arup Rakshit <aruprakshit1987@outlook.com>)
Список pgsql-general
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Arup Rakshit
Дата:
Сообщение: [GENERAL] filter records by substring match of an postgresql array column
Следующее
От: Arup Rakshit
Дата:
Сообщение: Re: [GENERAL] filter records by substring match of an postgresql array column