Comparing Arrays in Where or Having Clause
I want to check if given array_agg(column) is in the array of arrays I sent in the rpc,
consider following:
I want to check if ['A','B'] is in [['A','A'],['A','B']]
I looked around for array comparision in psql just found <@ and the && operator for checking subset or overlaping i.e exact arrays, how do I check if array is IN the array of arrays?
consider following:
I want to check if ['A','B'] is in [['A','A'],['A','B']]
I looked around for array comparision in psql just found <@ and the && operator for checking subset or overlaping i.e exact arrays, how do I check if array is IN the array of arrays?
