Re: "Oracle's ROWNUM"

I think you should look into the documentation for your particular
interface.  We generally use PHP as an interface.  We use the pg_exec
function to create an indexed result set from a connection and
statement.  Then we iterate through each indexed row, calling
pg_fetch_array so we can manipulate and display returned values.

Hope this answers your question!

-Ryan

At 11:03 PM 7/28/01 +0200, Svenne Krap wrote:

>Hi,
>
>is there any way to get the number of the tuple in the result set...
>
>in Oracle you can write
>
>select rownum, * from mytable;
>
>and then get (handmade example) :
>
>rownum | id | name
>-----------------------------
>1       | 27| John Dow
>2       | 09 | Jane Dow
>3       | 11 | Bugs Bunny

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01