Re: ordering rows
От | Bob Pawley |
---|---|
Тема | Re: ordering rows |
Дата | |
Msg-id | 007801c811a8$118fbdf0$6401a8c0@owner обсуждение исходный текст |
Ответ на | ordering rows (Bob Pawley <rjpawley@shaw.ca>) |
Список | pgsql-general |
That's marvelous - thanks. Bob ----- Original Message ----- From: "brian" <brian@zijn-digital.com> To: <pgsql-general@postgresql.org> Sent: Thursday, October 18, 2007 9:45 AM Subject: Re: [GENERAL] ordering rows > Bob Pawley wrote: >> Hi >> >> I have a table 'import' which is an amalgam of two other tables >> 'loops' and 'devices'. >> >> The ID column of loops is reflected in the import table. However the >> order of rows ends up as, a for instance, 6, 8, 7, 4, 5 3, 2, 1. > > These are the IDs from loops? > >> I need to fetch these rows one at a time, in sequence with the loop >> ID, to process them in a delphi interface before going on to the next >> row. > > ORDER BY loops.id ASC > >> Query- >> >> 1. Can I somehow ensure that the rows are transfered to the import >> table in numerical sequence with the ID of the loop table? > > Ensure that *what* is transferred? The rows from imports? Do they have a > foreign key pointing to loops? > >> 2. Is there a method of using the fetch command to ensure that rows >> are picked up sequentially - lowest ID to highest ID or vice-versa? >> >> 3. Is there another mehod of accomplishing this task other than >> fetch? >> > > Perhaps you should post your SELECT statement and a sample of the result > you're getting (and a sample of what you desire to get wouldn't hurt). > > brian > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings
В списке pgsql-general по дате отправления: