update data types from NUMERIC to DOUBLE_PRECISION
Closed this issue · 2 comments
Ludee commented
We will change data types from NUMERIC
and DECIMAL
to DOUBLE_PRECISION
openego/data_processing#72
ego.io has to be updated as well.
nesnoj commented
FLOAT
is a postgreSQL-specific type. The docs say
PostgreSQL also supports the SQL-standard notations float and float(p) for specifying inexact numeric types. Here, p specifies the minimum acceptable precision in binary digits. PostgreSQL accepts float(1) to float(24) as selecting the real type, while float(25) to float(53) select double precision. Values of p outside the allowed range draw an error. float with no precision specified is taken to mean double precision.
So you can simply replace FLOAT
by DOUBLE PRECISION
in dp as there're no occurences with specified precision.