postgresql - SQL Attribute is a list - Access one element of the list -


i have postgresql table x attribute names | character varying(255)[].

now, names in 1 entry { 'mary' , 'james' , 'john' }. how run query along lines -

select names,other_attribute_1 x 'mary' in names ; 

i need fetch (or attributes) of row names list has 'mary'.

you can use like operator:

select names,   other_attribute_1  x  names '%mary%'; 

Comments

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -