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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
