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/