TINYINT
MySQL
TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.
AI 代码解读
PostgreSQL
TINYINT 对应 PostgreSQL
postgres=# create domain tinyint as smallint constraint ck check (value between -127 and 128);
CREATE DOMAIN
TINYINT [UNSIGNED] 对应 PostgreSQL
postgres=# create domain utinyint as smallint constraint ck check (value between 0 and 255);
CREATE DOMAIN
AI 代码解读
boolean
MySQL
boolean
AI 代码解读
PostgreSQL
boolean
AI 代码解读
SMALLINT
MySQL
SMALLINT[(M)] [UNSIGNED] [ZEROFILL]
A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535.
AI 代码解读
PostgreSQL
SMALLINT[(M)] 对应 PostgreSQL
smallint
SMALLINT[(M)] [UNSIGNED] 对应 PostgreSQL
postgres=# create domain usmallint as int constraint ck check (value between 0 and 65535);
CREATE DOMAIN
AI 代码解读
MEDIUMINT
MySQL
MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]
The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215.
AI 代码解读
PostgreSQL
MEDIUMINT[(M)] 对应 PostgreSQL
postgres=# create domain MEDIUMINT as int constraint ck check (value between -8388608 and 8388607);
CREATE DOMAIN
MEDIUMINT[(M)] [UNSIGNED] 对应 PostgreSQL
postgres=# create domain UMEDIUMINT as int constraint ck check (value between 0 and 16777215);
CREATE DOMAIN
AI 代码解读
INT
MySQL
INT[(M)] [UNSIGNED]
INTEGER[(M)] [UNSIGNED] [ZEROFILL]
When marked UNSIGNED, it ranges from 0 to 4294967295, otherwise its range is -2147483648 to 2147483647 (SIGNED is the default).
AI 代码解读
PostgreSQL
INT[(M)] INTEGER[(M)] 对应 PostgreSQL
INT
INT[(M)] [UNSIGNED] 对应 PostgreSQL
INTEGER[(M)] [UNSIGNED] 对应 PostgreSQL
postgres=# create domain UINT as int8 constraint ck check (value between 0 and 4294967295);
CREATE DOMAIN
AI 代码解读
BIGINT
MySQL
BIGINT[(M)] [UNSIGNED] [ZEROFILL]
The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.
AI 代码解读
PostgreSQL
BIGINT[(M)] 对应 PostgreSQL
BIGINT
BIGINT[(M)] [UNSIGNED] 对应 PostgreSQL
postgres=# create domain UBIGINT as numeric(20,0) constraint ck check (value between 0 and 18446744073709551615);
CREATE DOMAIN
AI 代码解读
decimal, dec, numeric, fixed
MySQL
DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL]
DEC[(M[,D])] [UNSIGNED] [ZEROFILL]
NUMERIC[(M[,D])] [UNSIGNED] [ZEROFILL]
FIXED[(M[,D])] [UNSIGNED] [ZEROFILL]
AI 代码解读
PostgreSQL
DECIMAL[(M[,D])] 对应 PostgreSQL
decimal[(M[,D])]
DECIMAL[(M[,D])] [UNSIGNED] 对应 PostgreSQL
postgres=# create domain udecimal as numeric constraint ck check (value >=0);
CREATE DOMAIN
# 不能改domain的scale,precise.
AI 代码解读
FLOAT
MySQL
FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]
AI 代码解读
PostgreSQL
FLOAT[(M,D)] 对应 PostgreSQL
float4
FLOAT[(M,D)] [UNSIGNED] 对应 PostgreSQL
postgres=# create domain ufloat4 as float4 constraint ck check (value >=0);
CREATE DOMAIN
# 不能改domain的scale,precise.
AI 代码解读
DOUBLE
MySQL
DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]
DOUBLE PRECISION[(M,D)] [UNSIGNED] [ZEROFILL]
REAL[(M,D)] [UNSIGNED] [ZEROFILL]
AI 代码解读
PostgreSQL
DOUBLE[(M,D)]
DOUBLE PRECISION[(M,D)]
REAL[(M,D)] 对应 PostgreSQL
float8
DOUBLE[(M,D)] [UNSIGNED]
DOUBLE PRECISION[(M,D)] [UNSIGNED]
REAL[(M,D)] [UNSIGNED] 对应 PostgreSQL
postgres=# create domain ufloat8 as float8 constraint ck check (value >=0);
CREATE DOMAIN
# 不能改domain的scale,precise.
AI 代码解读
bit
MySQL
BIT[(M)]
A bit-field type. M indicates the number of bits per value, from 1 to 64. The default is 1 if M is omitted.
AI 代码解读
PostgreSQL
BIT[(M)]
AI 代码解读
