Pular para o conteúdo
This question has been flagged
fieldsdatasqlfloatfields.functiontypes
1 Responder
8795 Vistas
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
Descartar
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
Descartar
René Schuster
Autor

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

Related Posts Respostas Vistas Atividade
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
4671
create customer from opportunity transfer data for custom fields
fields data
Avatar
0
fev. 21
4154
MSSQL Data in Odoo
data etl sql
Avatar
Avatar
1
jun. 26
729
Setting User logged in as default
fields data studio
Avatar
0
set. 24
140
Custom float field auto rounding? Solved
fields float odoo
Avatar
Avatar
Avatar
4
set. 18
7333