Juan Manuel Diaz Lara <jmdiazlr(at)yahoo(dot)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 was wondering 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