Re: Why the planner is not using the INDEX .

* David Gagnon <dgagnon(at)siunik(dot)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(at)metux(dot)de
---------------------------------------------------------------------
Realtime Forex/Stock Exchange trading powered by postgresSQL :))
http://www.fxignal.net/
---------------------------------------------------------------------