Julien Cigar wrote:
> I finally found a solution:
>
> SELECT specimen_id
> FROM specimen_test_bits
> GROUP BY specimen_id
> HAVING array_accum(test_bit_id) = '{2,3,4}';
>
> .. but I don't think it's very "clean" ..
The key question is whether you can rely on getting (2,3,4) or whether
you might get (4,3,2) or some other ordering.
-- Richard Huxton Archonet Ltd
