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!