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
any input.
Thanks!
- 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
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 SQ
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 such
