Numeric - PostgreSQL
The table below lists Magic xpa’s Numeric attribute with the valid PostgreSQL data types.
Each entry in the table has a default data type that can be forced by specifying that type in the Type property on the SQL section in the Column Properties sheet.
|
|
|
|
|
|
Signed Integer
|
n = 1 - 4
|
2
|
SMALLINT
|
|
|
n = 5 - 9
|
4
|
INTEGER
|
|
Float
|
n >= 10 and precision(p) >=0
|
8
|
DOUBLE PRECISION
|
|
|
n+p <= 15
|
8
|
DOUBLE PRECISION
|
|
String Number
|
n+p >= 16
|
n + p
|
NUMERIC (n, p)
|
