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

Retrieve all the returned rows in one call

From: "Andreas Gidlund" <vaxis(at)hotmail(dot)com>
Subject: Retrieve all the returned rows in one call
Date: 2006-10-09 14:58:05
Message-ID: BAY103-F23CEDEF25EEDE7CAFCE5F9BA160@phx.gbl (view raw or flat)
Lists: pgsql-interfaces
I am right now using the libpq interface and struggling with efficiently 
retrieve the result from a query.

Let's say I run a select statement with some where clauses and then retrieve 
the result into a PGresult. I want to know if there is an efficient way to 
retrieve all the rows at once? I am going to return a char*** from my 
function, i.e. a two-dimensional array of char pointers.
I have seen the COPY sql command, but up to v8.1 i cannot use a select 
statement with it, the only way to customize COPY is to choose which columns 
to return, but still, the only option is to return the whole table. 
Furthermore, when using PQgetCopyData I get the whole row at once, but I 
still have to loop through all rows.
I have also seen in the PGresult structure that it has a member called 
tuples, which is a two-dimensional array of the structure PGresAttValue. 
This is a way to recieve all the data at once, but it is in a format which 
is specific for PostgreSQL and I am developing a database interface 
including other databases two, so I want to use a general structure returned 
from the function, i.e. a char***. This means that I would have to loop 
through the tuples array to convert into the char array structure, and hence 
lose the whole meaning with recieving all the rows at once.

So my question is if it is possible in any way to retrieve the result in the 
form of char***?

Gör karriär!


pgsql-interfaces by date

Next:From: Sean DavisDate: 2006-10-09 15:30:06
Subject: Re: Retrieve all the returned rows in one call
Previous:From: Jeroen T. VermeulenDate: 2006-10-02 06:51:38
Subject: Re: Compilations failing

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