[GENERAL] ordering rows

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. I need to fetch these rows one at a time, in sequence with the loop

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

Re: [GENERAL] ordering rows

That's marvelous - thanks. Bob - Original Message - From: brian [EMAIL PROTECTED] 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