Re: ALL() question
От
Richard Huxton
Тема
Re: ALL() question
Дата
Msg-id
473AF646.2010307@archonet.com
Ответ на
Re: ALL() question (Julien Cigar)
Список
Дерево обсуждения
ALL() question Julien Cigar <jcigar@ulb.ac.be>
Re: ALL() question hubert depesz lubaczewski <depesz@depesz.com>
Re: ALL() question Julien Cigar <jcigar@ulb.ac.be>
Re: ALL() question Richard Huxton <dev@archonet.com>
Re: ALL() question Julien Cigar <jcigar@ulb.ac.be>
Re: ALL() question Julien Cigar <jcigar@ulb.ac.be>
Re: ALL() question Richard Huxton <dev@archonet.com>
Re: ALL() question Richard Huxton <dev@archonet.com>
Re: ALL() question "Bart Degryse" <Bart.Degryse@indicator.be>
Re: ALL() question Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>
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
В списке pgsql-sql по дате отправления
