ECPG and Curors. - Mailing list pgsql-general

From Peter L. Berghold
Subject ECPG and Curors.
Date
Msg-id 448E2D90.9000800@Berghold.Net
Whole thread Raw
Responses Re: ECPG and Curors.
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm looking at the documentation for Postgresql in Chapter 30 and I'm
checking out how to use FETCH INTO and CURSORs to loop through multiple
results from a table.

In the documentation they show something like

EXEC SQL DECLARE foo CURSOR for select a,b,c from test_table

do {
EXEC SQL FETCH NEXT FROM foo INTO ....

} while ( ... );

what I don't see is how to detect that I've fetched the last row from a
query.   Is there more complete doco on this process somewhere?



- --
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Peter L. Berghold                                     Peter@Berghold.Net
"Those who fail to learn from history are condemned to repeat it."
AIM: redcowdawg        Yahoo IM: blue_cowdawg              ICQ: 11455958
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Red Hat - http://enigmail.mozdev.org

iD8DBQFEji2QUM9/01RIhaARAqV6AJ43/F6y5sKbvY837dVwNL8ZPz0MxgCeIJlL
5Fo3FyR3e5Aup53s/z0UrxY=
=RLxy
-----END PGP SIGNATURE-----

Attachment

pgsql-general by date:

Previous
From: John Tregea
Date:
Subject: Re: Help with storing spatial (map coordinates) data?
Next
From: John Tregea
Date:
Subject: Re: Help with storing spatial (map coordinates) data?