Say we create two tables (users and groups), where users are in groups:<\/p>\n
\ncreate table users (\n id int unique,\n name varchar unique\n);\n\ncreate table groups (\n id int unique,\n name varchar unique,\n member_users int[],\n member_groups int[]\n);\n<\/pre>\nThe groups own the user memberships, rather than having an intermediate table with the relation.<\/p>\n
Now, we want to join them, so we can simply do this:<\/p>\n
\nselect *\nfrom groups join users\n on users.id = ANY (groups.member_users)\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Say we create two tables (users and groups), where users are in groups: create table users ( id int unique, name varchar unique ); create table groups ( id int unique, name varchar unique, member_users int[], member_groups int[] ); The groups own the user memberships, rather than having an intermediate table with the relation. Now, … <\/p>\n