Re: integer[] indexing.

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: integer[] indexing.
Date: 2004-10-08 09:29:35
Message-ID: opsfjonlc0cq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


disclaimer : brainless proposition

(SELECT * FROM table WHERE (icount(ids) <= 1 AND ids[1] = 33)
UNION ALL
(SELECT * FROM table WHERE (icount(ids) > 1 AND ids && '{33}'));

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pierre-Frédéric Caillaud 2004-10-08 09:57:13 Re: sequential scan on select distinct
Previous Message Dawid Kuroczko 2004-10-08 09:11:16 integer[] indexing.