Re: Sorting Tuples

Hi Brian.

That's what actually I was trying to build in order to get it.

I was thinking about 2 nested query. The inner one just sorting the
output, something like:

SELECT * FROM huge_table ORDER BY a_column_of_huge_table ASC

The outer would compare for example the current tuple with the following
one and as you said
 "If it finds an index such that a[i] > a[i+1], you know the result isn't
sorted correctly."

Could you please write to me a sort of "what should that nested query be",
please?
Remark I'm not a database user and SQL is not that fresh to me.

Thank you Brian!

> My advice would be to write a quick application that creates a cursor of

> the sorted results, and sucks them out.  If it finds an index such that 
> a[i] > a[i+1], you know the result isn't sorted correctly.
> 
> Brian


-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice