Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

2

Call a funcion pl/pgsql

By
Joaquin
on 10/4/13, 10:48 AM 714 views

Hello.

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?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 10/4/13, 10:48 AM
Seen: 714 times
Last updated: 3/16/15, 8:10 AM