Hassan Adekoya wrote: > I will like to preserve ordering.... Tables are inherently unordered. If you want a particular order, you need to use the ORDER BY clause. And you will need to have a column to sort by. If you don't have one, the generate_series() function may help. This has nothing to do with performance, I gather, so it might be more appropriate for the pgsql-sql list. -- Peter Eisentraut http://developer.postgresql.org/~petere/
