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 that the order that I hope to preserved in destroyed. The same result set but different ordering. I gather this is due to the query planner. Enough said. I was hoping to insert a counter in the select query of 1. such that when I perform the join of 2, I can order by the counter. i.e. 1. select id, astext from function1(1,2) 2. select id, astext, table2.name from function1(1,2) as tmp, table2 where tmp.id = table2.id when I perform 1., I get something of sort id | astext 2 | abc 6 | efg 3 | fhg I will like to preserve ordering.... When I perform 2, I get somthing of sort id | astext | table2.name 6 | efg | joe 2 | abc | zyi 3 | fgh | mec Can someone help such that I get something like id | astext | table2.name | increment 6 | efg | joe | 2 2 | abc | zyi | 1 3 | fgh | mec | 3 Thanks! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
