Re: Why the planner is not using the INDEX . - Mailing list pgsql-performance

* David Gagnon <dgagnon@siunik.com> wrote:

> FOR inventoryTransaction IN
>        SELECT DISTINCT IRNUM, IRAENUM, IRSTATUT, IRSENS, IRSOURCE,
> IRDATE, IRQTE
>        FROM IR
>        WHERE IRNUM = ANY (requestIds) and IRYPNUM = companyId
>    LOOP

hmm. you probably could create the query dynamically and
then execute it.


BTW: why isn't IN not usable with arrays ?


cu
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service
  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact@metux.de
---------------------------------------------------------------------
  Realtime Forex/Stock Exchange trading powered by postgresSQL :))
                                            http://www.fxignal.net/
---------------------------------------------------------------------