Loop query

Posted on July 23, 2015 at 5:01am

Hi,

I have a simple postgresql query which returns three fields. I want to repeat that query in a loop. My "solution" right now is copy&paste the query several times with union, but this is not flexible. I want to repeat the query the number of times indicated in a parameter by the user. How can I do that?

Thanks in advance!

enol.cordero's picture
enol.cordero
71
Joined: Jul 21 2015 - 5:57am
Last seen: 8 years 2 months ago

1 Answer:

Posted on September 1, 2015 at 7:18pm

You can implement the repetition of the result set for N times in esProc easily, using the following code:

A1=$select f1,f2,f3 from tb

A2=A1*argN

Find more examples from http://blog.raqsoft.com/?p=4744 .

calculate.machine's picture
calculate.machine
1258
Joined: Jan 13 2015 - 11:40pm
Last seen: 7 years 10 months ago
Feedback