search

orbisgis / h2gis

A spatial extension of the H2 database.
http://www.h2gis.org
GNU Lesser General Public License v3.0
203 stars 62 forks source link

JDBCUtilities to list all numeric columns #1353

Closed ebocher closed 11 months ago

katzyn commented 11 months ago

Just wondering: why createTableDDL() generates FLOAT for DECFLOAT data type? These data types have nothing common with each other.

ebocher commented 11 months ago

I no longer remember ; ) may be related to postgresql. I will check. Best

katzyn commented 11 months ago

PostgreSQL doesn't have the DECFLOAT data type from the SQL Standard.

But PostgreSQL also has a documented incompatibility with the Standard in its NUMERIC data type. NUMERIC without parameters in PostgreSQL is similar to DECFLOAT.

(NUMERIC without parameters in H2 is compliant with the standard and cannot be used instead of DECFLOAT.)