Juan Manuel Diaz Lara <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings