Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] filter records by substring match of an postgresql array column - Mailing list pgsql-general

From Arup Rakshit
Subject [GENERAL] filter records by substring match of an postgresql array column
Date
Msg-id EA16EEB1-A784-4BBB-99DE-302C1708633B@outlook.com
Whole thread Raw
Responses Re: [GENERAL] filter records by substring match of an postgresqlarray column  (Jeff Janes <jeff.janes@gmail.com>)
Re: [GENERAL] filter records by substring match of an postgresql array column  (Arup Rakshit <aruprakshit1987@outlook.com>)
List pgsql-general
Tree view 
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
stringinside tag column matches a given substring. What method should I use? The *Contains `@>` operator* will do full
stringcomparisons as far as I understood. 

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: "Arnaud L."
Date:
Subject: [GENERAL] DROP INDEX hangs
Next
From: Jeff Janes
Date:
Subject: Re: [GENERAL] filter records by substring match of an postgresqlarray column