[...]
> I need to search a table to find sets of rows that have a column
matching
> itself for the whole set and another column matching row for row with a
> list I am going to supply. The result I should receive should be
value of
> the column that matches itself.
[...]
How about:
DROP TABLE IF EXISTS T;
CREATE TABLE T
(
id int,
val int
);
INSERT INTO T (id, val) VALUES
(3, 1),
(3, 2),
(4, 8),
(4, 9),
(4, 10);
SELECT
id
FROM
T
GROUP BY
id
HAVING
array_agg(val) = ARRAY[8, 9, 10];
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
