Re: How to implement oracle like rownum(function or seudocolumn) ?

Juan Manuel Diaz Lara <jmdiazlr@yahoo.com> writes:
> I need a rownum column, like Oracle. I have searched the mailing lists and I don't see a satisfactory solution, so I
waswondering write a UDF to implement it, the requirements are:
 

Try keeping a counter in fcinfo->flinfo->fn_extra.

>   3. And more important, need to be called in the right place when called from subquerys:

Don't expect miracles in this department.  The planner will evaluate the
function where it sees fit...
        regards, tom lane