Postgresql – Find a value based on all its present combinations with a value in another field in Postgres
I have a PostgreSQL table: create table test(type_id, m_id)as values (1, 123) ,(2, 456) ,(3, 123) ,(4, 123) ,(2, 456) ,(1, 789) ; Basically, one m_id could have multiple rows in this table associated with different type_ids. How can I…