azzumed

-- ----------------------------
-- Table structure for user_contacts
-- ----------------------------
DROP TABLE IF EXISTS "public"."user_contacts";
CREATE TABLE "public"."user_contacts" (
  "id" int8 NOT NULL DEFAULT nextval('user_contacts_id_seq'::regclass),
  "user_id" int8 NOT NULL,
  "contact_user_id" int8 NOT NULL
)
;

azzumed

-- Все взаимные контакты пользователя:
SELECT
	contact_user_id AS user_contact_id
FROM
	user_contacts uc
WHERE
	uc.user_id = 1 
	AND EXISTS (
		SELECT
			*