KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a view defined as: CREATE VIEW View1 AS SELECT Field1, Field2, array_agg(Field3) AS AggField FROM Table1 GROUP BY Field1, Field2; What I would like to do is get the intersection of the arrays in AggField with something like: SELECT intersection(AggField) FROM View1 WHERE Field2 = 'SomeValue'; Is this at all possible, or is there a better way to achieve what I want?
Tags (comma-separated)
Save Edits
Cancel