How can I retrieve a function result? - Mailing list pgsql-general

From Luis Alberto Pérez Paz
Subject How can I retrieve a function result?
Date
Msg-id 7f64980c0606121624l482ff0aax3c38cc889058e7fc@mail.gmail.com
Whole thread Raw
Responses Re: How can I retrieve a function result?
List 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)

pgsql-general by date:

Previous
From: "Milen Kulev"
Date:
Subject: Re: Partitioning...
Next
From: Joachim Wieland
Date:
Subject: Re: How can I retrieve a function result?