Beginner LevelPostgreSQL
How do PostgreSQL Array Operators (||, &&, @>, ANY) manipulate array fields?
❓ Interview Prompt: Explain array operators: concatenation (`||`), overlap (`&&`), containment (`@>`), and array searching (`WHERE val = ANY(array_col)`).
PostgreSQL provides comprehensive operators for searching and mutating native ARRAY columns:
•
'||': Array concatenation operator ('array || element').
•
'@>': Containment operator ('ARRAY[1,2,3] @> ARRAY[2]').
•
'ANY(array)': Searches if a scalar value equals any array element ('WHERE 'admin' = ANY(roles)').
Code Implementation Example
sql
-- Query users having 'admin' or 'editor' role
SELECT name, roles
FROM users
WHERE 'admin' = ANY(roles);
-- Append new tag to array column
UPDATE users SET tags = array_append(tags, 'verified') WHERE id = 101;💡Searching array columns with ANY() and mutating arrays via array_append.
🎯 Interview Key Takeaway
Use WHERE val = ANY(array_column) to search scalar items inside PostgreSQL array fields.
#ARRAY#Array Operators#ANY#Beginner
Back to all PostgreSQL Questions→