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.

0

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

By
René Schuster
on 5/23/14, 6:09 AM 1,213 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) ?

Thanks.

0
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

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: 5/23/14, 6:09 AM
Seen: 1213 times
Last updated: 3/16/15, 8:10 AM