Skip to Content
This question has been flagged
fieldsdatasqlfloatfields.functiontypes
1 Reply
7579 Views
Avatar
René Schuster

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.

Avatar
Discard
Avatar
Bruno Figares
Best Answer

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.

Avatar
Discard
René Schuster
Author

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

Related Posts Replies Views Activity
get data from two fields in module Sale and display it in a custom field in the same module
fields data
Avatar
Avatar
1
nov. 22
3663
create customer from opportunity transfer data for custom fields
fields data
Avatar
0
feb. 21
3049
Setting User logged in as default
fields data studio
Avatar
0
sep. 24
140
Custom float field auto rounding? Solved
fields float odoo
Avatar
Avatar
Avatar
4
sep. 18
6012
How to get data from table odoo v8?
fields data self.pool.get
Avatar
Avatar
Avatar
5
apr. 16
6819