Odoo Help


Are fields.float and fields.function (type='float') stored with different sql data types?

René Schuster
on 5/23/14, 6:09 AM 1,899 views

There are 2 datatypes for fixed point values and 4 for floating point numbers in SQL.

Which are used for fields.float and fields.function (type='float', store=True) ?


Bruno Figares
On 5/23/14, 9:14 AM

Hello René, it seems all of them use the 'numeric' datatype. You can check for yourself using psql and describing a table ( \d <table_name>). You can check this out in the account_voucher module with the account_voucher_line table. Install this module and then \d(escribe) the table. Hope this helps!

Best regards,

Bruno Figares.

I've done that and the result is: fields.float (no digit attribute): double precision. fields.function(type='float', store=True): numeric.

René Schuster
on 6/26/14, 9:30 AM

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/23/14, 6:09 AM
Seen: 1899 times
Last updated: 3/16/15, 8:10 AM