Re: Fwd: Silly question about numbering of rows? - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Fwd: Silly question about numbering of rows?
Date
Msg-id Pine.LNX.4.30.0103132042370.2274-100000@peter.localdomain
Whole thread Raw
In response to Fwd: Silly question about numbering of rows?  (Ken Corey <ken.corey@atomic-interactive.com>)
List pgsql-sql
Ken Corey writes:

> It sounds easiest to me to just punt and number the rows as they are returned
> in my calling application...

The rows are automatically numbered.  In libpq, you'd use
PQgetvalue(result, rownumber, fieldnumber).  Other interfaces have similar
functions.  If the interface has a "fetch"-like approach, it seems trivial
to keep a counter.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-sql by date:

Previous
From: "david morgan"
Date:
Subject: Re: error joining 2 views containing GROUP BYs
Next
From: Christopher Sawtell
Date:
Subject: Re: my pgsql error?