| 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: | Whole Thread | Raw Message | 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)
| 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... |