* David Gagnon <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] --------------------------------------------------------------------- Realtime Forex/Stock Exchange trading powered by postgresSQL :)) http://www.fxignal.net/ --------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
