I created a table with 50,000 rows and tried mine . I created a temp table to fill, so that the fetch loop did not penalise the performance, and took 79 milliseconds to build it ... SELECT * FROM tes… (View Post)

Oh - and if it's a lot more than 3 integers, go: WITHi(i) AS ( SELECT MICROSECOND(tm) FROM ( SELECT TIMESTAMPADD(MICROSECOND, 1,'2000-01-01'::TIMESTAMP) UNION ALL SELECT TIMESTAMPADD(M… (View Post)