Postgres Pro
Downloads
Home   >   mailing lists

Re: increment Rows in an SQL Result Set postgresql - Mailing list pgsql-performance

From Peter Eisentraut
Subject Re: increment Rows in an SQL Result Set postgresql
Date
Msg-id 200607160153.31333.peter_e@gmx.net
Whole thread Raw
In response to increment Rows in an SQL Result Set postgresql  (Hassan Adekoya <hechy_man@yahoo.com>)
List pgsql-performance
Tree view 
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/

pgsql-performance by date:

Previous
From: Gabriele Turchi
Date:
Subject: Re: Big differences in plans between 8.0 and 8.1
Next
From: Joe Conway
Date:
Subject: Re: Big differences in plans between 8.0 and 8.1