[PERFORM] increment Rows in an SQL Result Set postgresql

HI, 1. I have a function that given two parameter produces an arbitrary id, and text. However arbitrary the id and text are, they are in certain order. i.e. it is imperative that whatever processing I do, the order is preserved. 2. An odd thing happens when I perform a join on the result set

Re: [PERFORM] increment Rows in an SQL Result Set postgresql

Hassan, 1. I have a function that given two parameter produces an arbitrary id, and text. However arbitrary the id and text are, they are in certain order. i.e. it is imperative that whatever processing I do, the order is preserved. What type of function is this? Did you write it in C? An

Re: [PERFORM] increment Rows in an SQL Result Set postgresql

! - Hassan Adekoya - Original Message From: Craig A. James [EMAIL PROTECTED] To: Hassan Adekoya [EMAIL PROTECTED] Cc: pgsql-performance@postgresql.org Sent: Saturday, July 15, 2006 1:27:20 PM Subject: Re: [PERFORM] increment Rows in an SQL Result Set postgresql Hassan, 1. I have

Re: [PERFORM] increment Rows in an SQL Result Set postgresql

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