Structs§
- AbsFloat32
- AbsFloat64
- AbsInt16
- AbsInt32
- AbsInt64
- AbsNumeric
- AclItem
Grantee - AclItem
Grantor - AclItem
Privileges - Acos
- Acosh
- AddDate
Interval - AddDate
Time - AddFloat32
- AddFloat64
- AddInt16
- AddInt32
- AddInt64
- AddInterval
- AddNumeric
- AddTime
Interval - AddUint16
- AddUint32
- AddUint64
- Adjust
Numeric Scale - Adjust
Timestamp Precision - Adjust
Timestamp TzPrecision - AgeTimestamp
- AgeTimestamptz
- Array
Array Concat - Array
Contains - Array
Contains Array - Array
Contains Array Rev - Array
Length - Array
Lower - Array
Remove - Array
Upper - Ascii
- Asin
- Asinh
- Atan
- Atanh
- BitAnd
Int16 - BitAnd
Int32 - BitAnd
Int64 - BitAnd
Uint16 - BitAnd
Uint32 - BitAnd
Uint64 - BitCount
Bytes - BitLength
Bytes - BitLength
String - BitNot
Int16 - BitNot
Int32 - BitNot
Int64 - BitNot
Uint16 - BitNot
Uint32 - BitNot
Uint64 - BitOr
Int16 - BitOr
Int32 - BitOr
Int64 - BitOr
Uint16 - BitOr
Uint32 - BitOr
Uint64 - BitShift
Left Int16 - BitShift
Left Int32 - BitShift
Left Int64 - BitShift
Left Uint16 - BitShift
Left Uint32 - BitShift
Left Uint64 - BitShift
Right Int16 - BitShift
Right Int32 - BitShift
Right Int64 - BitShift
Right Uint16 - BitShift
Right Uint32 - BitShift
Right Uint64 - BitXor
Int16 - BitXor
Int32 - BitXor
Int64 - BitXor
Uint16 - BitXor
Uint32 - BitXor
Uint64 - Byte
Length Bytes - Byte
Length String - Cast
Array ToArray - Casts an array of one type to an array of another type. Does so by casting each element of the first array to the desired inner type and collecting the results into a new array.
- Cast
Array ToJsonb - Cast
Array ToList OneDim - Cast
Array ToString - Cast
Bool ToInt32 - Cast
Bool ToInt64 - Cast
Bool ToString - Cast
Bool ToString Nonstandard - Cast
Bytes ToString - Cast
Char ToString - Cast
Date ToMz Timestamp - Cast
Date ToString - Cast
Date ToTimestamp - Cast
Date ToTimestamp Tz - Cast
Float32 ToFloat64 - Cast
Float32 ToInt16 - Cast
Float32 ToInt32 - Cast
Float32 ToInt64 - Cast
Float32 ToNumeric - Cast
Float32 ToString - Cast
Float32 ToUint16 - Cast
Float32 ToUint32 - Cast
Float32 ToUint64 - Cast
Float64 ToFloat32 - Cast
Float64 ToInt16 - Cast
Float64 ToInt32 - Cast
Float64 ToInt64 - Cast
Float64 ToNumeric - Cast
Float64 ToString - Cast
Float64 ToUint16 - Cast
Float64 ToUint32 - Cast
Float64 ToUint64 - Cast
Int2 Vector ToArray - Cast
Int2 Vector ToString - Cast
Int16 ToFloat32 - Cast
Int16 ToFloat64 - Cast
Int16 ToInt32 - Cast
Int16 ToInt64 - Cast
Int16 ToNumeric - Cast
Int16 ToString - Cast
Int16 ToUint16 - Cast
Int16 ToUint32 - Cast
Int16 ToUint64 - Cast
Int32 ToBool - Cast
Int32 ToFloat32 - Cast
Int32 ToFloat64 - Cast
Int32 ToInt16 - Cast
Int32 ToInt64 - Cast
Int32 ToMz Timestamp - Cast
Int32 ToNumeric - Cast
Int32 ToOid - Cast
Int32 ToPg Legacy Char - Cast
Int32 ToString - Cast
Int32 ToUint16 - Cast
Int32 ToUint32 - Cast
Int32 ToUint64 - Cast
Int64 ToBool - Cast
Int64 ToFloat32 - Cast
Int64 ToFloat64 - Cast
Int64 ToInt16 - Cast
Int64 ToInt32 - Cast
Int64 ToMz Timestamp - Cast
Int64 ToNumeric - Cast
Int64 ToOid - Cast
Int64 ToString - Cast
Int64 ToUint16 - Cast
Int64 ToUint32 - Cast
Int64 ToUint64 - Cast
Interval ToString - Cast
Interval ToTime - Cast
Jsonb ToBool - Cast
Jsonb ToFloat32 - Cast
Jsonb ToFloat64 - Cast
Jsonb ToInt16 - Cast
Jsonb ToInt32 - Cast
Jsonb ToInt64 - Cast
Jsonb ToNumeric - Cast
Jsonb ToString - Cast
Jsonbable ToJsonb - Cast
List1 ToList2 - Casts between two list types by casting each element of
a(“list1”) usingcast_exprand collecting the results into a new list (“list2”). - Cast
List ToJsonb - Cast
List ToString - Cast
MapTo String - Cast
MzTimestamp ToString - Cast
MzTimestamp ToTimestamp - Cast
MzTimestamp ToTimestamp Tz - Cast
Numeric ToFloat32 - Cast
Numeric ToFloat64 - Cast
Numeric ToInt16 - Cast
Numeric ToInt32 - Cast
Numeric ToInt64 - Cast
Numeric ToMz Timestamp - Cast
Numeric ToString - Cast
Numeric ToUint16 - Cast
Numeric ToUint32 - Cast
Numeric ToUint64 - Cast
OidTo Int32 - Cast
OidTo Int64 - Cast
OidTo RegClass - Cast
OidTo RegProc - Cast
OidTo RegType - Cast
OidTo String - Cast
PgLegacy Char ToChar - Cast
PgLegacy Char ToInt32 - Cast
PgLegacy Char ToString - Cast
PgLegacy Char ToVar Char - Cast
Range ToString - Cast
Record1 ToRecord2 - Casts between two record types by casting each element of
a(“record1”) usingcast_exprand collecting the results into a new record (“record2”). - Cast
Record ToString - Cast
RegClass ToOid - Cast
RegProc ToOid - Cast
RegType ToOid - Cast
String ToArray - Cast
String ToBool - Cast
String ToBytes - Cast
String ToChar - Cast
String ToDate - Cast
String ToFloat32 - Cast
String ToFloat64 - Cast
String ToInt2 Vector - Cast
String ToInt16 - Cast
String ToInt32 - Cast
String ToInt64 - Cast
String ToInterval - Cast
String ToJsonb - Cast
String ToList - Cast
String ToMap - Cast
String ToMz Timestamp - Cast
String ToNumeric - Cast
String ToOid - Cast
String ToPg Legacy Char - Cast
String ToPg Legacy Name - Cast
String ToRange - Cast
String ToTime - Cast
String ToTimestamp - Cast
String ToTimestamp Tz - Cast
String ToUint16 - Cast
String ToUint32 - Cast
String ToUint64 - Cast
String ToUuid - Cast
String ToVar Char - Cast
Time ToInterval - Cast
Time ToString - Cast
Timestamp ToDate - Cast
Timestamp ToMz Timestamp - Cast
Timestamp ToString - Cast
Timestamp ToTime - Cast
Timestamp ToTimestamp Tz - Cast
Timestamp TzTo Date - Cast
Timestamp TzTo MzTimestamp - Cast
Timestamp TzTo String - Cast
Timestamp TzTo Time - Cast
Timestamp TzTo Timestamp - Cast
Uint16 ToFloat32 - Cast
Uint16 ToFloat64 - Cast
Uint16 ToInt16 - Cast
Uint16 ToInt32 - Cast
Uint16 ToInt64 - Cast
Uint16 ToNumeric - Cast
Uint16 ToString - Cast
Uint16 ToUint32 - Cast
Uint16 ToUint64 - Cast
Uint32 ToFloat32 - Cast
Uint32 ToFloat64 - Cast
Uint32 ToInt16 - Cast
Uint32 ToInt32 - Cast
Uint32 ToInt64 - Cast
Uint32 ToMz Timestamp - Cast
Uint32 ToNumeric - Cast
Uint32 ToString - Cast
Uint32 ToUint16 - Cast
Uint32 ToUint64 - Cast
Uint64 ToFloat32 - Cast
Uint64 ToFloat64 - Cast
Uint64 ToInt16 - Cast
Uint64 ToInt32 - Cast
Uint64 ToInt64 - Cast
Uint64 ToMz Timestamp - Cast
Uint64 ToNumeric - Cast
Uint64 ToString - Cast
Uint64 ToUint16 - Cast
Uint64 ToUint32 - Cast
Uuid ToString - Cast
VarChar ToString - Cbrt
Float64 - Ceil
Float32 - Ceil
Float64 - Ceil
Numeric - Char
Length - Chr
- Constant
Time EqBytes - Constant
Time EqString - Convert
From - Cos
- Cosh
- Cot
- Crc32
Bytes - Crc32
String - Date
BinTimestamp - Date
BinTimestamp Tz - Date
Part Interval - Date
Part Interval F64 - Date
Part Interval Numeric - Date
Part Time - Date
Part Time F64 - Date
Part Time Numeric - Date
Part Timestamp - Date
Part Timestamp Timestamp F64 - Date
Part Timestamp Timestamp Numeric - Date
Part Timestamp Timestamp TzF64 - Date
Part Timestamp Timestamp TzNumeric - Date
Part Timestamp Tz - Date
Trunc Interval - Date
Trunc Timestamp - Date
Trunc Timestamp Tz - Date
Trunc Units Timestamp - Date
Trunc Units Timestamp Tz - Decode
- Degrees
- Digest
Bytes - Digest
String - DivFloat32
- DivFloat64
- DivInt16
- DivInt32
- DivInt64
- DivInterval
- DivNumeric
- DivUint16
- DivUint32
- DivUint64
- Element
List Concat - Encode
- Encoded
Bytes Char Length - Eq
- Exp
- ExpNumeric
- Extract
Date - Extract
Date Units - Extract
Interval - Extract
Time - Extract
Timestamp - Extract
Timestamp Tz - Floor
Float32 - Floor
Float64 - Floor
Numeric - GetBit
- GetByte
- Gt
- Gte
- Initcap
- IsFalse
- IsLike
Match - IsNull
- IsRegexp
Match - IsTrue
- Jsonb
Array Length - Jsonb
Concat - Jsonb
Contains Jsonb - Jsonb
Contains String - Jsonb
Delete Int64 - Jsonb
Delete String - Jsonb
Pretty - Jsonb
Strip Nulls - Jsonb
Typeof - Justify
Days - Justify
Hours - Justify
Interval - Kafka
Murmur2 Bytes - Kafka
Murmur2 String - Left
- Like
Escape - List
Contains List - List
Contains List Rev - List
Element Concat - List
Length - List
List Concat - List
Remove - Ln
- LnNumeric
- Log10
- Log10
Numeric - LogBase
Numeric - Lower
- Lt
- Lte
- MapBuild
From Record List - MapContains
AllKeys - MapContains
AnyKeys - MapContains
Key - MapContains
Map - MapGet
Value - MapLength
- ModFloat32
- ModFloat64
- ModInt16
- ModInt32
- ModInt64
- ModNumeric
- ModUint16
- ModUint32
- ModUint64
- MulFloat32
- MulFloat64
- MulInt16
- MulInt32
- MulInt64
- MulInterval
- MulNumeric
- MulUint16
- MulUint32
- MulUint64
- MzAcl
Item Contains Privilege - MzAcl
Item Grantee - MzAcl
Item Grantor - MzAcl
Item Privileges - MzFormat
Privileges - MzRender
Typmod - MzRow
Size - MzType
Name - MzValidate
Privileges - MzValidate
Role Privilege - NegFloat32
- NegFloat64
- NegInt16
- NegInt32
- NegInt64
- NegInterval
- NegNumeric
- Not
- NotEq
- PadChar
- All Char data is stored in Datum::String with its blank padding removed (i.e. trimmed), so this function provides a means of restoring any removed padding.
- Panic
- Parse
Ident - PgColumn
Size - PgSize
Pretty - Position
- Power
- Power
Numeric - Pretty
Sql - Quote
Ident - Radians
- Range
Adjacent - Range
After - Range
Before - Range
Contains Date - Range
Contains Date Rev - Range
Contains I32 - Range
Contains I64 - Range
Contains I32Rev - Range
Contains I64Rev - Range
Contains Numeric - Range
Contains Numeric Rev - Range
Contains Range - Range
Contains Range Rev - Range
Contains Timestamp - Range
Contains Timestamp Rev - Range
Contains Timestamp Tz - Range
Contains Timestamp TzRev - Range
Difference - Range
Empty - Range
Intersection - Range
Lower - Range
Lower Inc - Range
Lower Inf - Range
Overlaps - Range
Overleft - Range
Overright - Range
Union - Range
Upper - Range
Upper Inc - Range
Upper Inf - Record
Get - Regexp
Match - Regexp
Split ToArray - Reverse
- Right
- Round
Float32 - Round
Float64 - Round
Numeric - Round
Numeric Binary - Seahash
Bytes - Seahash
String - Sin
- Sinh
- Sleep
- Sqrt
Float64 - Sqrt
Numeric - Starts
With - Step
MzTimestamp - SubDate
- SubDate
Interval - SubFloat32
- SubFloat64
- SubInt16
- SubInt32
- SubInt64
- SubInterval
- SubNumeric
- SubTime
- SubTime
Interval - SubTimestamp
- SubTimestamptz
- SubUint16
- SubUint32
- SubUint64
- Tan
- Tanh
- Text
Concat Binary - Timezone
Offset - Timezone
Time - Timezone
Timestamp - Timezone
Timestamp Tz - ToChar
Timestamp - ToChar
Timestamp Format - ToChar
Timestamp Tz - ToChar
Timestamp TzFormat - ToTimestamp
- Trim
- Trim
Leading - Trim
Leading Whitespace - Trim
Trailing - Trim
Trailing Whitespace - Trim
Whitespace - Trunc
Float32 - Trunc
Float64 - Trunc
Numeric - TryParse
Monotonic Iso8601 Timestamp - Upper
- Uuid
Generate V5
Enums§
Functions§
- abs_
float32 - abs_
float64 - abs_
int16 - abs_
int32 - abs_
int64 - abs_
numeric - acl_
item_ grantee - acl_
item_ grantor - acl_
item_ privileges - acos
- acosh
- add_
timestamp_ months - and
- ascii
- asin
- asinh
- atan
- atanh
- bit_
count_ bytes - bit_
length_ bytes - bit_
length_ string - bit_
not_ int16 - bit_
not_ int32 - bit_
not_ int64 - bit_
not_ uint16 - bit_
not_ uint32 - bit_
not_ uint64 - build_
regex - byte_
length_ bytes - byte_
length_ string - cast_
bool_ to_ int32 - cast_
bool_ to_ int64 - cast_
bool_ to_ string - cast_
bool_ to_ string_ nonstandard - cast_
bytes_ to_ string - cast_
char_ to_ string - cast_
date_ to_ mz_ timestamp - cast_
date_ to_ string - cast_
float32_ to_ float64 - cast_
float32_ to_ int16 - cast_
float32_ to_ int32 - cast_
float32_ to_ int64 - cast_
float32_ to_ string - cast_
float32_ to_ uint16 - cast_
float32_ to_ uint32 - cast_
float32_ to_ uint64 - cast_
float64_ to_ float32 - cast_
float64_ to_ int16 - cast_
float64_ to_ int32 - cast_
float64_ to_ int64 - cast_
float64_ to_ string - cast_
float64_ to_ uint16 - cast_
float64_ to_ uint32 - cast_
float64_ to_ uint64 - cast_
int16_ to_ float32 - cast_
int16_ to_ float64 - cast_
int16_ to_ int32 - cast_
int16_ to_ int64 - cast_
int16_ to_ string - cast_
int16_ to_ uint16 - cast_
int16_ to_ uint32 - cast_
int16_ to_ uint64 - cast_
int32_ to_ bool - cast_
int32_ to_ float32 - cast_
int32_ to_ float64 - cast_
int32_ to_ int16 - cast_
int32_ to_ int64 - cast_
int32_ to_ mz_ timestamp - cast_
int32_ to_ oid - cast_
int32_ to_ pg_ legacy_ char - cast_
int32_ to_ string - cast_
int32_ to_ uint16 - cast_
int32_ to_ uint32 - cast_
int32_ to_ uint64 - cast_
int64_ to_ bool - cast_
int64_ to_ float32 - cast_
int64_ to_ float64 - cast_
int64_ to_ int16 - cast_
int64_ to_ int32 - cast_
int64_ to_ mz_ timestamp - cast_
int64_ to_ oid - cast_
int64_ to_ string - cast_
int64_ to_ uint16 - cast_
int64_ to_ uint32 - cast_
int64_ to_ uint64 - cast_
interval_ to_ string - cast_
interval_ to_ time - cast_
jsonb_ to_ bool - cast_
jsonb_ to_ float32 - cast_
jsonb_ to_ float64 - cast_
jsonb_ to_ int16 - cast_
jsonb_ to_ int32 - cast_
jsonb_ to_ int64 - cast_
jsonb_ to_ string - cast_
jsonbable_ to_ jsonb - cast_
mz_ timestamp_ to_ string - cast_
mz_ timestamp_ to_ timestamp - cast_
mz_ timestamp_ to_ timestamp_ tz - cast_
numeric_ to_ float32 - cast_
numeric_ to_ float64 - cast_
numeric_ to_ int16 - cast_
numeric_ to_ int32 - cast_
numeric_ to_ int64 - cast_
numeric_ to_ mz_ timestamp - cast_
numeric_ to_ string - cast_
numeric_ to_ uint16 - cast_
numeric_ to_ uint32 - cast_
numeric_ to_ uint64 - cast_
oid_ to_ int32 - cast_
oid_ to_ int64 - cast_
oid_ to_ reg_ class - cast_
oid_ to_ reg_ proc - cast_
oid_ to_ reg_ type - cast_
oid_ to_ string - cast_
pg_ legacy_ char_ to_ char - cast_
pg_ legacy_ char_ to_ int32 - cast_
pg_ legacy_ char_ to_ string - cast_
pg_ legacy_ char_ to_ var_ char - cast_
reg_ class_ to_ oid - cast_
reg_ proc_ to_ oid - cast_
reg_ type_ to_ oid - cast_
string_ to_ bool - cast_
string_ to_ bytes - cast_
string_ to_ date - cast_
string_ to_ float32 - cast_
string_ to_ float64 - cast_
string_ to_ int16 - cast_
string_ to_ int32 - cast_
string_ to_ int64 - cast_
string_ to_ interval - cast_
string_ to_ jsonb - cast_
string_ to_ mz_ timestamp - cast_
string_ to_ oid - cast_
string_ to_ pg_ legacy_ char - cast_
string_ to_ pg_ legacy_ name - cast_
string_ to_ time - cast_
string_ to_ uint16 - cast_
string_ to_ uint32 - cast_
string_ to_ uint64 - cast_
string_ to_ uuid - cast_
time_ to_ interval - cast_
time_ to_ string - cast_
timestamp_ to_ date - cast_
timestamp_ to_ mz_ timestamp - cast_
timestamp_ to_ string - cast_
timestamp_ to_ time - cast_
timestamp_ tz_ to_ date - cast_
timestamp_ tz_ to_ mz_ timestamp - cast_
timestamp_ tz_ to_ string - cast_
timestamp_ tz_ to_ time - cast_
uint16_ to_ float32 - cast_
uint16_ to_ float64 - cast_
uint16_ to_ int16 - cast_
uint16_ to_ int32 - cast_
uint16_ to_ int64 - cast_
uint16_ to_ string - cast_
uint16_ to_ uint32 - cast_
uint16_ to_ uint64 - cast_
uint32_ to_ float32 - cast_
uint32_ to_ float64 - cast_
uint32_ to_ int16 - cast_
uint32_ to_ int32 - cast_
uint32_ to_ int64 - cast_
uint32_ to_ mz_ timestamp - cast_
uint32_ to_ string - cast_
uint32_ to_ uint16 - cast_
uint32_ to_ uint64 - cast_
uint64_ to_ float32 - cast_
uint64_ to_ float64 - cast_
uint64_ to_ int16 - cast_
uint64_ to_ int32 - cast_
uint64_ to_ int64 - cast_
uint64_ to_ mz_ timestamp - cast_
uint64_ to_ string - cast_
uint64_ to_ uint16 - cast_
uint64_ to_ uint32 - cast_
uuid_ to_ string - cast_
var_ char_ to_ string - cbrt_
float64 - ceil_
float32 - ceil_
float64 - ceil_
numeric - char_
length - chr
- constant_
time_ eq_ bytes - constant_
time_ eq_ string - cos
- cosh
- cot
- crc32_
bytes - crc32_
string - date_
bin - date_
part_ interval_ inner - date_
part_ time_ inner - date_
part_ timestamp_ inner - date_
trunc_ inner - degrees
- exp
- exp_
numeric - extract_
date_ inner - floor_
float32 - floor_
float64 - floor_
numeric - format_
pg_ legacy_ char - hmac_
bytes - hmac_
inner - hmac_
string - initcap
- is_
false - is_null
- is_true
- jsonb_
array_ length - jsonb_
pretty - jsonb_
stringify - jsonb_
strip_ nulls - jsonb_
typeof - justify_
days - justify_
hours - justify_
interval - kafka_
murmur2_ bytes - kafka_
murmur2_ string - ln
- ln_
numeric - log10
- log10_
numeric - lower
- mz_
acl_ item_ grantee - mz_
acl_ item_ grantor - mz_
acl_ item_ privileges - mz_
format_ privileges - mz_
row_ size - mz_
type_ name - mz_
validate_ privileges - mz_
validate_ role_ privilege - neg_
float32 - neg_
float64 - neg_
int16 - neg_
int32 - neg_
int64 - neg_
interval - neg_
numeric - not
- or
- panic
- pg_
column_ size - pg_
size_ pretty - radians
- range_
empty - range_
lower_ inc - range_
lower_ inf - range_
upper_ inc - range_
upper_ inf - reverse
- round_
float32 - round_
float64 - round_
numeric - seahash_
bytes - seahash_
string - sin
- sinh
- sleep
- sqrt_
float64 - sqrt_
numeric - step_
mz_ timestamp - tan
- tanh
- timezone_
time - Converts the time
t, which is assumed to be in UTC, to the timezonetz. For example,ESTand17:39:14would return12:39:14. - timezone_
timestamp - Converts the timestamp
dt, which is assumed to be in the time of the timezonetzto a timestamptz in UTC. This operation is fallible because certain timestamps at timezones that observe DST are simply impossible or ambiguous. In case of ambiguity (when a hour repeats) we will prefer the latest variant, and when an hour is impossible, we will attempt to fix it by advancing it. For example,ESTand2020-11-11T12:39:14would return2020-11-11T17:39:14Z. A DST observing timezone likeAmerica/New_Yorkwould cause the following DST anomalies:2020-11-01T00:59:59->2020-11-01T04:59:59Zand2020-11-01T01:00:00->2020-11-01T06:00:00Z2020-03-08T02:59:59->2020-03-08T07:59:59Zand2020-03-08T03:00:00->2020-03-08T07:00:00Z - timezone_
timestamptz - Converts the UTC timestamptz
utcto the local timestamp of the timezonetz. For example,ESTand2020-11-11T17:39:14Zwould return2020-11-11T12:39:14. - to_
timestamp - trim_
leading_ whitespace - trim_
trailing_ whitespace - trim_
whitespace - trunc_
float32 - trunc_
float64 - trunc_
numeric - try_
parse_ monotonic_ iso8601_ timestamp - upper