Statics§
- _LINKME_
ELEMENT_ πbool_ out_ boolean_ varchar - _LINKME_
ELEMENT_ πcast_ anyarray_ anyarray - _LINKME_
ELEMENT_ πcast_ anyarray_ varchar - _LINKME_
ELEMENT_ πcast_ anymap_ anymap - _LINKME_
ELEMENT_ πcast_ boolean_ int4 - _LINKME_
ELEMENT_ πcast_ boolean_ varchar - _LINKME_
ELEMENT_ πcast_ bytea_ varchar - _LINKME_
ELEMENT_ πcast_ date_ timestamp - _LINKME_
ELEMENT_ πcast_ date_ varchar - _LINKME_
ELEMENT_ πcast_ decimal_ float4 - _LINKME_
ELEMENT_ πcast_ decimal_ float8 - _LINKME_
ELEMENT_ πcast_ decimal_ int2 - _LINKME_
ELEMENT_ πcast_ decimal_ int4 - _LINKME_
ELEMENT_ πcast_ decimal_ int8 - _LINKME_
ELEMENT_ πcast_ decimal_ varchar - _LINKME_
ELEMENT_ πcast_ float4_ decimal - _LINKME_
ELEMENT_ πcast_ float4_ float8 - _LINKME_
ELEMENT_ πcast_ float4_ int2 - _LINKME_
ELEMENT_ πcast_ float4_ int4 - _LINKME_
ELEMENT_ πcast_ float4_ int8 - _LINKME_
ELEMENT_ πcast_ float4_ varchar - _LINKME_
ELEMENT_ πcast_ float8_ decimal - _LINKME_
ELEMENT_ πcast_ float8_ float4 - _LINKME_
ELEMENT_ πcast_ float8_ int2 - _LINKME_
ELEMENT_ πcast_ float8_ int4 - _LINKME_
ELEMENT_ πcast_ float8_ int8 - _LINKME_
ELEMENT_ πcast_ float8_ varchar - _LINKME_
ELEMENT_ πcast_ int2_ decimal - _LINKME_
ELEMENT_ πcast_ int2_ float4 - _LINKME_
ELEMENT_ πcast_ int2_ float8 - _LINKME_
ELEMENT_ πcast_ int2_ int4 - _LINKME_
ELEMENT_ πcast_ int2_ int8 - _LINKME_
ELEMENT_ πcast_ int2_ int256 - _LINKME_
ELEMENT_ πcast_ int2_ varchar - _LINKME_
ELEMENT_ πcast_ int4_ boolean - _LINKME_
ELEMENT_ πcast_ int4_ decimal - _LINKME_
ELEMENT_ πcast_ int4_ float4 - _LINKME_
ELEMENT_ πcast_ int4_ float8 - _LINKME_
ELEMENT_ πcast_ int4_ int2 - _LINKME_
ELEMENT_ πcast_ int4_ int8 - _LINKME_
ELEMENT_ πcast_ int4_ int256 - _LINKME_
ELEMENT_ πcast_ int4_ varchar - _LINKME_
ELEMENT_ πcast_ int8_ decimal - _LINKME_
ELEMENT_ πcast_ int8_ float4 - _LINKME_
ELEMENT_ πcast_ int8_ float8 - _LINKME_
ELEMENT_ πcast_ int8_ int2 - _LINKME_
ELEMENT_ πcast_ int8_ int4 - _LINKME_
ELEMENT_ πcast_ int8_ int256 - _LINKME_
ELEMENT_ πcast_ int8_ serial - _LINKME_
ELEMENT_ πcast_ int8_ varchar - _LINKME_
ELEMENT_ πcast_ int256_ float8 - _LINKME_
ELEMENT_ πcast_ int256_ varchar - _LINKME_
ELEMENT_ πcast_ interval_ time - _LINKME_
ELEMENT_ πcast_ interval_ varchar - _LINKME_
ELEMENT_ πcast_ jsonb_ boolean - _LINKME_
ELEMENT_ πcast_ jsonb_ decimal - _LINKME_
ELEMENT_ πcast_ jsonb_ float4 - _LINKME_
ELEMENT_ πcast_ jsonb_ float8 - _LINKME_
ELEMENT_ πcast_ jsonb_ int2 - _LINKME_
ELEMENT_ πcast_ jsonb_ int4 - _LINKME_
ELEMENT_ πcast_ jsonb_ int8 - _LINKME_
ELEMENT_ πcast_ jsonb_ varchar - _LINKME_
ELEMENT_ πcast_ serial_ int8 - _LINKME_
ELEMENT_ πcast_ struct_ struct - _LINKME_
ELEMENT_ πcast_ time_ interval - _LINKME_
ELEMENT_ πcast_ time_ varchar - _LINKME_
ELEMENT_ πcast_ timestamp_ date - _LINKME_
ELEMENT_ πcast_ timestamp_ time - _LINKME_
ELEMENT_ πcast_ timestamp_ varchar - _LINKME_
ELEMENT_ πcast_ varchar_ anyarray - _LINKME_
ELEMENT_ πcast_ varchar_ boolean - _LINKME_
ELEMENT_ πcast_ varchar_ bytea - _LINKME_
ELEMENT_ πcast_ varchar_ date - _LINKME_
ELEMENT_ πcast_ varchar_ decimal - _LINKME_
ELEMENT_ πcast_ varchar_ float4 - _LINKME_
ELEMENT_ πcast_ varchar_ float8 - _LINKME_
ELEMENT_ πcast_ varchar_ int2 - _LINKME_
ELEMENT_ πcast_ varchar_ int4 - _LINKME_
ELEMENT_ πcast_ varchar_ int8 - _LINKME_
ELEMENT_ πcast_ varchar_ int256 - _LINKME_
ELEMENT_ πcast_ varchar_ interval - _LINKME_
ELEMENT_ πcast_ varchar_ jsonb - _LINKME_
ELEMENT_ πcast_ varchar_ time - _LINKME_
ELEMENT_ πcast_ varchar_ timestamp - _LINKME_
ELEMENT_ πcast_ varchar_ varchar - _LINKME_
ELEMENT_ πpgwire_ recv_ bytea_ int8 - _LINKME_
ELEMENT_ πpgwire_ send_ int8_ bytea
Functions§
- bool_
out bool_out
is different fromcast(boolean) -> varchar
to produce a single char.PostgreSQL
uses different variants of bool-to-string in different situations.- bool_
out_ πboolean_ varchar - bool_
to_ varchar - cast
- cast_
anyarray_ πanyarray - cast_
anyarray_ πvarchar - cast_
anymap_ πanymap - cast_
boolean_ πint4 - cast_
boolean_ πvarchar - cast_
bytea_ πvarchar - cast_
date_ πtimestamp - cast_
date_ πvarchar - cast_
decimal_ πfloat4 - cast_
decimal_ πfloat8 - cast_
decimal_ πint2 - cast_
decimal_ πint4 - cast_
decimal_ πint8 - cast_
decimal_ πvarchar - cast_
float4_ πdecimal - cast_
float4_ πfloat8 - cast_
float4_ πint2 - cast_
float4_ πint4 - cast_
float4_ πint8 - cast_
float4_ πvarchar - cast_
float8_ πdecimal - cast_
float8_ πfloat4 - cast_
float8_ πint2 - cast_
float8_ πint4 - cast_
float8_ πint8 - cast_
float8_ πvarchar - cast_
int2_ πdecimal - cast_
int2_ πfloat4 - cast_
int2_ πfloat8 - cast_
int2_ πint4 - cast_
int2_ πint8 - cast_
int2_ πint256 - cast_
int2_ πvarchar - cast_
int4_ πboolean - cast_
int4_ πdecimal - cast_
int4_ πfloat4 - cast_
int4_ πfloat8 - cast_
int4_ πint2 - cast_
int4_ πint8 - cast_
int4_ πint256 - cast_
int4_ πvarchar - cast_
int8_ πdecimal - cast_
int8_ πfloat4 - cast_
int8_ πfloat8 - cast_
int8_ πint2 - cast_
int8_ πint4 - cast_
int8_ πint256 - cast_
int8_ πserial - cast_
int8_ πvarchar - cast_
int256_ πfloat8 - cast_
int256_ πvarchar - cast_
interval_ πtime - cast_
interval_ πvarchar - cast_
jsonb_ πboolean - cast_
jsonb_ πdecimal - cast_
jsonb_ πfloat4 - cast_
jsonb_ πfloat8 - cast_
jsonb_ πint2 - cast_
jsonb_ πint4 - cast_
jsonb_ πint8 - cast_
jsonb_ πvarchar - cast_
serial_ πint8 - cast_
struct_ πstruct - cast_
time_ πinterval - cast_
time_ πvarchar - cast_
timestamp_ πdate - cast_
timestamp_ πtime - cast_
timestamp_ πvarchar - cast_
varchar_ πanyarray - cast_
varchar_ πboolean - cast_
varchar_ πbytea - cast_
varchar_ πdate - cast_
varchar_ πdecimal - cast_
varchar_ πfloat4 - cast_
varchar_ πfloat8 - cast_
varchar_ πint2 - cast_
varchar_ πint4 - cast_
varchar_ πint8 - cast_
varchar_ πint256 - cast_
varchar_ πinterval - cast_
varchar_ πjsonb - cast_
varchar_ πtime - cast_
varchar_ πtimestamp - cast_
varchar_ πvarchar - general_
to_ text - For most of the types, cast them to varchar is the same as their pgwire βTEXTβ format.
So we use
ToText
to cast type to varchar. - int_
to_ bool - jsonb_
to_ bool - jsonb_
to_ number - Note that PostgreSQL casts JSON numbers from arbitrary precision
numeric
but we usef64
. This is less powerful but still meets RFC 8259 interoperability. - list_
cast π - Cast array with
source_elem_type
into array withtarget_elem_type
by casting each element. - map_
cast π - Cast array with
source_elem_type
into array withtarget_elem_type
by casting each element. - pgwire_
recv - pgwire_
recv_ πbytea_ int8 - pgwire_
send π - pgwire_
send_ πint8_ bytea - str_
parse - str_
to_ bool - str_
to_ bytea - str_
to_ πlist - struct_
cast π - Cast struct of
source_elem_type
totarget_elem_type
by casting each element. - to_
int256 - try_
cast