3 ms·
Is there no equivalent to https://dba.stackexchange.com/questions/86724/how-to-create-a-temporary-table-using-values-in-postgresql https://dba.stackexchange.com
by eximius 7y ago
Is there no equivalent to https://dba.stackexchange.com/questions/86724/how-to-create-a-temporary-table-using-values-in-postgresql https://dba.stackexchange.com/questions/86724/how-to-create-... outside postgres to join against?
- cafard 7y agoHow about select x, y from (select -1 * (rownum - 1) as x from all_objects where rownum <= 10000), (select rownum as y from all_objects where rownum <= 100) Wrap it in another SELECT * FROM () if you wish.