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 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!