Skip site navigation (1) Skip section navigation (2)

LIBPQ - FETCH INTO

From: "Michael GUIARD" <michael(at)nestor-tech(dot)com>
To: <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: LIBPQ - FETCH INTO
Date: 2005-07-28 13:55:42
Message-ID: 017101c5937c$0f0f35d0$027ba8c0@NSTMike (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
Hi !

first, thank you Magnus for your help :)

the use of cursors and fetch commands works fine for me. 
Is it possible to know the result length (rows count) before any retreive ?

Another thing, now I'd like to retreive the results, using FETCH command, into a structure. For example I ask for selecting 2 fields, instead of using PQgetvalue(res, i, j), I'd like to retreive all fields in a C structure.
I saw the FETCH INTO command, I tried to use it with the PQexecParams but I did not succeeded in.

Is it possible ? if yes how ?
thanks

Mike



pgsql-hackers-win32 by date

Next:From: Audrey Bergeron-MorinDate: 2005-07-28 15:46:14
Subject: Re: Can't connect after restart
Previous:From: Tom LaneDate: 2005-07-28 05:46:14
Subject: Re: Query on support for trigger functions defined in a Shared library in Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group