Re: increment Rows in an SQL Result Set postgresql

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: increment Rows in an SQL Result Set postgresql
Дата
Msg-id 200607160153.31333.peter_e@gmx.net
обсуждение исходный текст
Ответ на increment Rows in an SQL Result Set postgresql  (Hassan Adekoya <hechy_man@yahoo.com>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Gabriele Turchi
Дата:
Сообщение: Re: Big differences in plans between 8.0 and 8.1
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Big differences in plans between 8.0 and 8.1