Server：CentOS 7.2.1511
KingbaseES：V8R6C5B23
\dC+ 查看类型转换列表
test=# \dC+
类型转换列表
来源类型 | 目标类型 | 函数 | 隐含的? | 描述
-----------------------------+-----------------------------+--------------------+----------+------
bigint | bit | bit | 否 |
bigint | double precision | float8 | 是 |
bigint | integer | int4 | 在指派中 |
bigint | money | money | 在指派中 |
bigint | numeric | numeric | 是 |
bigint | oid | oid | 是 |
bigint | real | float4 | 是 |
bigint | regclass | oid | 是 |
bigint | regconfig | oid | 是 |
bigint | regdictionary | oid | 是 |
bigint | regnamespace | oid | 是 |
bigint | regoper | oid | 是 |
bigint | regoperator | oid | 是 |
bigint | regproc | oid | 是 |
bigint | regprocedure | oid | 是 |
bigint | regrole | oid | 是 |
bigint | regtype | oid | 是 |
bigint | smallint | int2 | 在指派中 |
bigint | text | text | 是 |
bigint | tinyint | tinyint | 在指派中 |
bit | bigint | int8 | 否 |
bit | bit | bit | 是 |
bit | bit varying | (binary coercible) | 是 |
bit | integer | int4 | 否 |
bit varying | bit | (binary coercible) | 是 |
bit varying | bit varying | varbit | 是 |
boolean | character | text | 在指派中 |
boolean | character varying | text | 在指派中 |
boolean | integer | int4 | 是 |
boolean | numeric | bool_to_numeric | 在指派中 |
boolean | text | text | 在指派中 |
boolean | tinyint | tinyint | 在指派中 |
box | circle | circle | 否 |
box | lseg | lseg | 否 |
box | point | point | 否 |
box | polygon | polygon | 在指派中 |
"char" | character | bpchar | 在指派中 |
"char" | character varying | text | 在指派中 |
"char" | integer | int4 | 否 |
"char" | text | text | 是 |
character | bigint | int8 | 是 |
character | bigint | int8 | 是 |
character | "char" | char | 在指派中 |
character | character | bpchar | 是 |
character | character | (binary coercible) | 是 |
character | character | bpcharbyte | 是 |
character | character | (binary coercible) | 在指派中 |
character | character varying | (binary coercible) | 是 |
character | character varying | (binary coercible) | 是 |
character | character varying | (binary coercible) | 是 |
character | character varying | text | 是 |
character | double precision | float8 | 是 |
character | double precision | float8 | 是 |
character | integer | int4 | 是 |
character | integer | int4 | 是 |
character | name | name | 是 |
character | numeric | text_numeric | 是 |
character | numeric | text_numeric | 是 |
character | real | float4 | 是 |
character | real | float4 | 是 |
character | smallint | int2 | 是 |
character | smallint | int2 | 是 |
character | text | (binary coercible) | 是 |
character | text | (binary coercible) | 是 |
character | timestamp without time zone | text_timestamp | 是 |
character | timestamp without time zone | text_timestamp | 是 |
character | timestamp with time zone | timestamptz | 是 |
character | timestamp with time zone | timestamptz | 是 |
character | time without time zone | text_time | 是 |
character | time with time zone | text_timetz | 是 |
character | tinyint | tinyint | 是 |
character | tinyint | tinyint | 是 |
character | xml | xml | 在指派中 |
character varying | bigint | int8 | 是 |
character varying | bigint | int8 | 是 |
character varying | bytea | (with inout) | 是 |
character varying | bytea | (with inout) | 是 |
character varying | "char" | char | 在指派中 |
character varying | character | (binary coercible) | 在指派中 |
character varying | character | (binary coercible) | 在指派中 |
character varying | character | (binary coercible) | 在指派中 |
character varying | character | (binary coercible) | 在指派中 |
character varying | character varying | (binary coercible) | 是 |
character varying | character varying | varchar | 是 |
character varying | character varying | varcharbyte | 是 |
character varying | character varying | (binary coercible) | 在指派中 |
character varying | double precision | float8 | 是 |
character varying | double precision | float8 | 是 |
character varying | integer | int4 | 是 |
character varying | integer | int4 | 是 |
character varying | name | name | 是 |
character varying | numeric | text_numeric | 是 |
character varying | numeric | text_numeric | 是 |
character varying | real | float4 | 是 |
character varying | real | float4 | 是 |
character varying | regclass | regclass | 是 |
character varying | smallint | int2 | 是 |
character varying | smallint | int2 | 是 |
character varying | text | (binary coercible) | 是 |
character varying | text | (binary coercible) | 是 |
character varying | timestamp without time zone | text_timestamp | 是 |
character varying | timestamp without time zone | text_timestamp | 是 |
character varying | timestamp with time zone | timestamptz | 是 |
character varying | timestamp with time zone | timestamptz | 是 |
character varying | time without time zone | text_time | 是 |
character varying | time with time zone | text_timetz | 是 |
character varying | tinyint | tinyint | 是 |
character varying | tinyint | tinyint | 是 |
character varying | xml | xml | 在指派中 |
cidr | character | text | 在指派中 |
cidr | character varying | text | 在指派中 |
cidr | inet | (binary coercible) | 是 |
cidr | text | text | 在指派中 |
circle | box | box | 否 |
circle | point | point | 否 |
circle | polygon | polygon | 否 |
double precision | bigint | int8 | 在指派中 |
double precision | integer | int4 | 在指派中 |
double precision | numeric | numeric | 在指派中 |
double precision | real | float4 | 在指派中 |
double precision | smallint | int2 | 在指派中 |
double precision | text | text | 是 |
double precision | tinyint | tinyint | 在指派中 |
inet | character | text | 在指派中 |
inet | character varying | text | 在指派中 |
inet | cidr | cidr | 在指派中 |
inet | text | text | 在指派中 |
integer | bigint | int8 | 是 |
integer | bit | bit | 否 |
integer | boolean | bool | 是 |
integer | "char" | char | 否 |
integer | double precision | float8 | 是 |
integer | money | money | 在指派中 |
integer | numeric | numeric | 是 |
integer | oid | (binary coercible) | 是 |
integer | real | float4 | 是 |
integer | regclass | (binary coercible) | 是 |
integer | regconfig | (binary coercible) | 是 |
integer | regdictionary | (binary coercible) | 是 |
integer | regnamespace | (binary coercible) | 是 |
integer | regoper | (binary coercible) | 是 |
integer | regoperator | (binary coercible) | 是 |
integer | regproc | (binary coercible) | 是 |
integer | regprocedure | (binary coercible) | 是 |
integer | regrole | (binary coercible) | 是 |
integer | regtype | (binary coercible) | 是 |
integer | smallint | int2 | 在指派中 |
integer | text | text | 是 |
integer | tinyint | tinyint | 在指派中 |
interval | interval | interval | 是 |
interval | time without time zone | time | 在指派中 |
json | jsonb | (with inout) | 在指派中 |
jsonb | bigint | int8 | 否 |
jsonb | boolean | bool | 否 |
jsonb | double precision | float8 | 否 |
jsonb | integer | int4 | 否 |
jsonb | json | (with inout) | 在指派中 |
jsonb | numeric | numeric | 否 |
jsonb | real | float4 | 否 |
jsonb | smallint | int2 | 否 |
lseg | point | point | 否 |
macaddr | macaddr8 | macaddr8 | 是 |
macaddr8 | macaddr | macaddr | 是 |
money | numeric | numeric | 在指派中 |
name | character | bpchar | 在指派中 |
name | character varying | varchar | 在指派中 |
name | text | text | 是 |
numeric | bigint | int8 | 在指派中 |
numeric | double precision | float8 | 是 |
numeric | integer | int4 | 在指派中 |
numeric | money | money | 在指派中 |
numeric | numeric | numeric | 是 |
numeric | real | float4 | 是 |
numeric | smallint | int2 | 在指派中 |
numeric | text | numeric_text | 是 |
numeric | tinyint | tinyint | 在指派中 |
oid | bigint | int8 | 在指派中 |
oid | integer | (binary coercible) | 在指派中 |
oid | regclass | (binary coercible) | 是 |
oid | regconfig | (binary coercible) | 是 |
oid | regdictionary | (binary coercible) | 是 |
oid | regnamespace | (binary coercible) | 是 |
oid | regoper | (binary coercible) | 是 |
oid | regoperator | (binary coercible) | 是 |
oid | regproc | (binary coercible) | 是 |
oid | regprocedure | (binary coercible) | 是 |
oid | regrole | (binary coercible) | 是 |
oid | regtype | (binary coercible) | 是 |
path | point | point | 否 |
path | polygon | polygon | 在指派中 |
pg_catalog.date | timestamp without time zone | timestamp | 是 |
pg_catalog.date | timestamp with time zone | timestamptz | 是 |
pg_dependencies | bytea | (binary coercible) | 是 |
pg_dependencies | text | (with inout) | 是 |
pg_mcv_list | bytea | (binary coercible) | 是 |
pg_mcv_list | text | (with inout) | 是 |
pg_ndistinct | bytea | (binary coercible) | 是 |
pg_ndistinct | text | (with inout) | 是 |
pg_node_tree | text | (binary coercible) | 是 |
point | box | box | 在指派中 |
polygon | box | box | 否 |
polygon | circle | circle | 否 |
polygon | path | path | 在指派中 |
polygon | point | point | 否 |
real | bigint | int8 | 在指派中 |
real | double precision | float8 | 是 |
real | integer | int4 | 在指派中 |
real | numeric | numeric | 在指派中 |
real | smallint | int2 | 在指派中 |
real | text | text | 是 |
real | tinyint | tinyint | 在指派中 |
regclass | bigint | int8 | 在指派中 |
regclass | integer | (binary coercible) | 在指派中 |
regclass | oid | (binary coercible) | 是 |
regconfig | bigint | int8 | 在指派中 |
regconfig | integer | (binary coercible) | 在指派中 |
regconfig | oid | (binary coercible) | 是 |
regdictionary | bigint | int8 | 在指派中 |
regdictionary | integer | (binary coercible) | 在指派中 |
regdictionary | oid | (binary coercible) | 是 |
regnamespace | bigint | int8 | 在指派中 |
regnamespace | integer | (binary coercible) | 在指派中 |
regnamespace | oid | (binary coercible) | 是 |
regoper | bigint | int8 | 在指派中 |
regoper | integer | (binary coercible) | 在指派中 |
regoper | oid | (binary coercible) | 是 |
regoper | regoperator | (binary coercible) | 是 |
regoperator | bigint | int8 | 在指派中 |
regoperator | integer | (binary coercible) | 在指派中 |
regoperator | oid | (binary coercible) | 是 |
regoperator | regoper | (binary coercible) | 是 |
regproc | bigint | int8 | 在指派中 |
regproc | integer | (binary coercible) | 在指派中 |
regproc | oid | (binary coercible) | 是 |
regproc | regprocedure | (binary coercible) | 是 |
regprocedure | bigint | int8 | 在指派中 |
regprocedure | integer | (binary coercible) | 在指派中 |
regprocedure | oid | (binary coercible) | 是 |
regprocedure | regproc | (binary coercible) | 是 |
regrole | bigint | int8 | 在指派中 |
regrole | integer | (binary coercible) | 在指派中 |
regrole | oid | (binary coercible) | 是 |
regtype | bigint | int8 | 在指派中 |
regtype | integer | (binary coercible) | 在指派中 |
regtype | oid | (binary coercible) | 是 |
smallint | bigint | int8 | 是 |
smallint | double precision | float8 | 是 |
smallint | integer | int4 | 是 |
smallint | numeric | numeric | 是 |
smallint | oid | int4 | 是 |
smallint | real | float4 | 是 |
smallint | regclass | int4 | 是 |
smallint | regconfig | int4 | 是 |
smallint | regdictionary | int4 | 是 |
smallint | regnamespace | int4 | 是 |
smallint | regoper | int4 | 是 |
smallint | regoperator | int4 | 是 |
smallint | regproc | int4 | 是 |
smallint | regprocedure | int4 | 是 |
smallint | regrole | int4 | 是 |
smallint | regtype | int4 | 是 |
smallint | text | text | 是 |
smallint | tinyint | tinyint | 在指派中 |
text | bigint | int8 | 是 |
text | "char" | char | 在指派中 |
text | character | (binary coercible) | 是 |
text | character | (binary coercible) | 是 |
text | character varying | (binary coercible) | 是 |
text | character varying | (binary coercible) | 是 |
text | double precision | float8 | 是 |
text | integer | int4 | 是 |
text | name | name | 是 |
text | numeric | text_numeric | 是 |
text | real | float4 | 是 |
text | regclass | regclass | 是 |
text | smallint | int2 | 是 |
text | timestamp without time zone | text_timestamp | 是 |
text | timestamp with time zone | timestamptz | 是 |
text | time without time zone | text_time | 是 |
text | time with time zone | text_timetz | 是 |
text | tinyint | tinyint | 是 |
text | xml | xml | 在指派中 |
timestamp without time zone | pg_catalog.date | date | 在指派中 |
timestamp without time zone | text | text | 是 |
timestamp without time zone | timestamp without time zone | timestamp | 是 |
timestamp without time zone | timestamp with time zone | timestamptz | 是 |
timestamp without time zone | time without time zone | time | 在指派中 |
timestamp with time zone | pg_catalog.date | date | 在指派中 |
timestamp with time zone | text | text | 是 |
timestamp with time zone | timestamp without time zone | timestamp | 在指派中 |
timestamp with time zone | timestamp with time zone | timestamptz | 是 |
timestamp with time zone | time without time zone | time | 在指派中 |
timestamp with time zone | time with time zone | timetz | 在指派中 |
time without time zone | interval | interval | 是 |
time without time zone | time without time zone | time | 是 |
time without time zone | time with time zone | timetz | 是 |
time with time zone | time without time zone | time | 在指派中 |
time with time zone | time with time zone | timetz | 是 |
tinyint | bigint | int8 | 是 |
tinyint | boolean | bool | 在指派中 |
tinyint | character | text | 在指派中 |
tinyint | character | text | 在指派中 |
tinyint | character varying | text | 在指派中 |
tinyint | character varying | text | 在指派中 |
tinyint | double precision | float8 | 是 |
tinyint | integer | int4 | 是 |
tinyint | numeric | tinyinttonumeric | 是 |
tinyint | real | float4 | 是 |
tinyint | smallint | int2 | 是 |
tinyint | text | text | 是 |
xml | character | (binary coercible) | 在指派中 |
xml | character varying | (binary coercible) | 在指派中 |
xml | text | (binary coercible) | 在指派中 |
(313 行记录)
学习资料
欢迎各位同学一起来交流学习心得！
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
