Read through all values in an array in PostgreSQL

Same applies to Greenplum:

select col1,array1 from schema.table WHERE 'value_to_search_for'= ANY(array1);

array1 is a column in the table with type name[] in this case

Comments

Popular posts from this blog

Database, schema, and table sizes in Greenplum

Greenplum update with multiple tables

Show running queries on Postgresql/Greenplum