How can I retrieve a function result?

From: Luis Alberto Pérez Paz <midriasis(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How can I retrieve a function result?
Date: 2006-06-12 23:24:24
Message-ID: 7f64980c0606121624l482ff0aax3c38cc889058e7fc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi pgsql community,

I'm using libpq C. I'm trying to execute a FUNCTION called "myFunction",

*********************************************************************************************************
PGResult *res;
res = PQexecParams ( conn, "select myFunction($1,$2,$3)" , 3, NULL,
paramValues, paraLenghts, paramFormats, resultFormat);

if ( PQresultStatus (res) != PGRES_TUPLES_OK)
{
//error
}else{
//ok
}

*********************************************************************************************************

It's works fine, however I dont know how can I retrieve the result that
return the FUNCTION "myFunction". "myFunction" is a postgres FUNCTION which
returns a INT.

Any advices??

thanks in advance.

Luis.

--
paz, amor y comprensión
(1967-1994)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brent Wood 2006-06-12 23:33:42 Re: Help with storing spatial (map coordinates) data?
Previous Message Milen Kulev 2006-06-12 23:04:55 Re: Partitioning...