Call a funcion pl/pgsql
I have a number of functions in the PostgreSQL database containing business logic which does not want to lose.
I need the data that is processed in these functions, they can be collected in a OpenERP module, to be treated in OpenERP.
But as I can not make the call to that function in PL / PGSQL and how to treat the data. Since PostgreSQL, one of the calls is this: select expediciones_totales (364);
The function returns a record like this: "(tot_merc, 22797.34)" "(tot_merc_fe, 25986.59)" "(tot_merc_fr, 3189.25)" "(tot_fact_emi_merc, 25986.59)" "(tot_fact_reci_merc, 3189.25)"
How I can make the call to the function from OpenERP and more importantly, esotos collect data in a consistent way to interpret?