Re: Fwd: Silly question about numbering of rows?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Ken Corey <ken(dot)corey(at)atomic-interactive(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Fwd: Silly question about numbering of rows?
Date: 2001-03-13 19:44:33
Message-ID: Pine.LNX.4.30.0103132042370.2274-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net http://yi.org/peter-e/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Sawtell 2001-03-13 20:06:54 Re: my pgsql error?
Previous Message Najm Hashmi 2001-03-13 16:33:10 Max Conncection limit?