Re: How to implement oracle like rownum(function or seudocolumn) ? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: How to implement oracle like rownum(function or seudocolumn) ?
Date
Msg-id 23603.1144514766@sss.pgh.pa.us
Whole thread Raw
In response to How to implement oracle like rownum(function or seudocolumn) ?  (Juan Manuel Diaz Lara <jmdiazlr@yahoo.com>)
Responses Re: How to implement oracle like rownum(function or seudocolumn) ?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Juan Manuel Diaz Lara
Date:
Subject: How to implement oracle like rownum(function or seudocolumn) ?
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Support Parallel Query Execution in Executor