ODBC call syntax returns 1 column instead of n columns

------=_Part_83683_4428624.1182463281583
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Greetings everybody,

I am currently writing an application in C++ that uses ODBC to connect to a
PGSQL database, and have run into an interesting issue regarding the escape
sequence "{call ([params])}". Here's a bit of information about my
current configuration. I'm using Ubuntu Edgy Eft using the following
packages:
odbc-postgresql (1:8.01.0200-2)
postgresql-8.1 (8.1.9-ubuntu0.6.10)
libodbc++ 0.2.3+0.2.4pre3-1
iodbc 3.52.4-3

My problem is this. Suppose the following SQL code was executed:

-- Create test source

CREATE TABLE "odbc_test_table" (

  "testid" serial NOT NULL PRIMARY KEY,

  "start" timestamp NOT NULL DEFAULT localtimestamp,

  "end" timestamp

);



-- Populate it with some data

INSERT INTO "odbc_test_table"("end") VALUES('2007/07/23 00:00:00');

INSERT INTO "odbc_test_table"("end") VALUES(NULL);



-- Create return type

CREATE TYPE odbc_test_fun_t AS (

 "testid" int,

 "ttl"    interval

);



-- Create test function

CREATE FUNCTION odbc_test_fun () RETURNS odbc_test_fun_t AS

'SELECT "testid", age("end",localtimestamp) AS ttl FROM odbc_test_table;'

LANGUAGE 'sql';

#include 

#include 

#include 

#include 

#include 

#include 

#include 



using namespace odbc;

using namespace std;



void call_ps(PreparedStatement* s) {

 ResultSet* r = s->executeQuery();

 ResultSetMetaData *rm = r->getMetaData();



 switch (rm->getColumnCount()) {

  case 2:

    while(r->next()) {

     string ttl = r->getString(2);

     if (r->wasNull())

    ttl = "";

     cout << "Two Cols: ID=" << r->getInt(1) << ", TTL=" <<

    ttl << endl;

    }

    break;

  case 1:

    while(r->next()) {

     cout << "One col: " << r->getString(1) << endl;

    }

    break;

  default:

    cout << "Uh...." << endl;

 }

}



int main() {

 //

 Connection *c = DriverManager::getConnection("DSN=msafe_psql");

 PreparedStatement *select = c->prepareStatement(

    "select * from odbc_test_fun()");

 PreparedStatement *call = c->prepareStatement(

    "{call odbc_test_fun()}");



 call_ps(select);

 call_ps(call);



 DriverManager::shutdown();



 return 0;

}