Module func Copy item path Source AbsFloat32 AbsFloat64 AbsInt16 AbsInt32 AbsInt64 AbsNumeric AclItemGrantee AclItemGrantor AclItemPrivileges Acos Acosh AddDateInterval AddDateTime AddFloat32 AddFloat64 AddInt16 AddInt32 AddInt64 AddInterval AddNumeric AddTimeInterval AddTimestampInterval AddTimestampTzInterval AddUint16 AddUint32 AddUint64 AdjustNumericScale AdjustTimestampPrecision AdjustTimestampTzPrecision AgeTimestamp AgeTimestampTz ArrayArrayConcat ArrayContains ArrayContainsArray ArrayContainsArrayRev ArrayLength ArrayLower ArrayRemove ArrayUpper Ascii Asin Asinh Atan Atanh BitAndInt16 BitAndInt32 BitAndInt64 BitAndUint16 BitAndUint32 BitAndUint64 BitCountBytes BitLengthBytes BitLengthString BitNotInt16 BitNotInt32 BitNotInt64 BitNotUint16 BitNotUint32 BitNotUint64 BitOrInt16 BitOrInt32 BitOrInt64 BitOrUint16 BitOrUint32 BitOrUint64 BitShiftLeftInt16 BitShiftLeftInt32 BitShiftLeftInt64 BitShiftLeftUint16 BitShiftLeftUint32 BitShiftLeftUint64 BitShiftRightInt16 BitShiftRightInt32 BitShiftRightInt64 BitShiftRightUint16 BitShiftRightUint32 BitShiftRightUint64 BitXorInt16 BitXorInt32 BitXorInt64 BitXorUint16 BitXorUint32 BitXorUint64 ByteLengthBytes ByteLengthString CastArrayToArray 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. CastArrayToJsonb CastArrayToListOneDim CastArrayToString CastBoolToInt32 CastBoolToInt64 CastBoolToString CastBoolToStringNonstandard CastBytesToString CastCharToString CastDateToMzTimestamp CastDateToString CastDateToTimestamp CastDateToTimestampTz CastFloat32ToFloat64 CastFloat32ToInt16 CastFloat32ToInt32 CastFloat32ToInt64 CastFloat32ToNumeric CastFloat32ToString CastFloat32ToUint16 CastFloat32ToUint32 CastFloat32ToUint64 CastFloat64ToFloat32 CastFloat64ToInt16 CastFloat64ToInt32 CastFloat64ToInt64 CastFloat64ToNumeric CastFloat64ToString CastFloat64ToUint16 CastFloat64ToUint32 CastFloat64ToUint64 CastInt2VectorToArray CastInt2VectorToString CastInt16ToFloat32 CastInt16ToFloat64 CastInt16ToInt32 CastInt16ToInt64 CastInt16ToNumeric CastInt16ToString CastInt16ToUint16 CastInt16ToUint32 CastInt16ToUint64 CastInt32ToBool CastInt32ToFloat32 CastInt32ToFloat64 CastInt32ToInt16 CastInt32ToInt64 CastInt32ToMzTimestamp CastInt32ToNumeric CastInt32ToOid CastInt32ToPgLegacyChar CastInt32ToString CastInt32ToUint16 CastInt32ToUint32 CastInt32ToUint64 CastInt64ToBool CastInt64ToFloat32 CastInt64ToFloat64 CastInt64ToInt16 CastInt64ToInt32 CastInt64ToMzTimestamp CastInt64ToNumeric CastInt64ToOid CastInt64ToString CastInt64ToUint16 CastInt64ToUint32 CastInt64ToUint64 CastIntervalToString CastIntervalToTime CastJsonbToBool CastJsonbToFloat32 CastJsonbToFloat64 CastJsonbToInt16 CastJsonbToInt32 CastJsonbToInt64 CastJsonbToNumeric CastJsonbToString CastJsonbableToJsonb CastList1ToList2 Casts between two list types by casting each element of a (“list1”) using
cast_expr and collecting the results into a new list (“list2”). CastListToJsonb CastListToString CastMapToString CastMzTimestampToString CastMzTimestampToTimestamp CastMzTimestampToTimestampTz CastNumericToFloat32 CastNumericToFloat64 CastNumericToInt16 CastNumericToInt32 CastNumericToInt64 CastNumericToMzTimestamp CastNumericToString CastNumericToUint16 CastNumericToUint32 CastNumericToUint64 CastOidToInt32 CastOidToInt64 CastOidToRegClass CastOidToRegProc CastOidToRegType CastOidToString CastPgLegacyCharToChar CastPgLegacyCharToInt32 CastPgLegacyCharToString CastPgLegacyCharToVarChar CastRangeToString CastRecord1ToRecord2 Casts between two record types by casting each element of a (“record1”) using
cast_expr and collecting the results into a new record (“record2”). CastRecordToString CastRegClassToOid CastRegProcToOid CastRegTypeToOid CastStringToArray CastStringToBool CastStringToBytes CastStringToChar CastStringToDate CastStringToFloat32 CastStringToFloat64 CastStringToInt2Vector CastStringToInt16 CastStringToInt32 CastStringToInt64 CastStringToInterval CastStringToJsonb CastStringToList CastStringToMap CastStringToMzTimestamp CastStringToNumeric CastStringToOid CastStringToPgLegacyChar CastStringToPgLegacyName CastStringToRange CastStringToTime CastStringToTimestamp CastStringToTimestampTz CastStringToUint16 CastStringToUint32 CastStringToUint64 CastStringToUuid CastStringToVarChar CastTimeToInterval CastTimeToString CastTimestampToDate CastTimestampToMzTimestamp CastTimestampToString CastTimestampToTime CastTimestampToTimestampTz CastTimestampTzToDate CastTimestampTzToMzTimestamp CastTimestampTzToString CastTimestampTzToTime CastTimestampTzToTimestamp CastUint16ToFloat32 CastUint16ToFloat64 CastUint16ToInt16 CastUint16ToInt32 CastUint16ToInt64 CastUint16ToNumeric CastUint16ToString CastUint16ToUint32 CastUint16ToUint64 CastUint32ToFloat32 CastUint32ToFloat64 CastUint32ToInt16 CastUint32ToInt32 CastUint32ToInt64 CastUint32ToMzTimestamp CastUint32ToNumeric CastUint32ToString CastUint32ToUint16 CastUint32ToUint64 CastUint64ToFloat32 CastUint64ToFloat64 CastUint64ToInt16 CastUint64ToInt32 CastUint64ToInt64 CastUint64ToMzTimestamp CastUint64ToNumeric CastUint64ToString CastUint64ToUint16 CastUint64ToUint32 CastUuidToString CastVarCharToString CbrtFloat64 CeilFloat32 CeilFloat64 CeilNumeric CharLength Chr ConstantTimeEqBytes ConstantTimeEqString ConvertFrom Cos Cosh Cot Crc32Bytes Crc32String DateBinTimestamp DateBinTimestampTz DatePartInterval DatePartIntervalF64 DatePartIntervalNumeric DatePartTime DatePartTimeF64 DatePartTimeNumeric DatePartTimestamp DatePartTimestampTimestampF64 DatePartTimestampTimestampNumeric DatePartTimestampTimestampTzF64 DatePartTimestampTimestampTzNumeric DatePartTimestampTz DateTruncInterval DateTruncTimestamp DateTruncTimestampTz DateTruncUnitsTimestamp DateTruncUnitsTimestampTz Decode Degrees DigestBytes DigestString DivFloat32 DivFloat64 DivInt16 DivInt32 DivInt64 DivInterval DivNumeric DivUint16 DivUint32 DivUint64 ElementListConcat Encode EncodedBytesCharLength Eq Exp ExpNumeric ExtractDate ExtractDateUnits ExtractInterval ExtractTime ExtractTimestamp ExtractTimestampTz FloorFloat32 FloorFloat64 FloorNumeric GetBit GetByte Gt Gte Initcap IsFalse IsLikeMatch IsLikeMatchCaseInsensitive IsLikeMatchCaseSensitive IsNull IsRegexpMatch IsTrue JsonbArrayLength JsonbConcat JsonbContainsJsonb JsonbContainsString JsonbDeleteInt64 JsonbDeleteString JsonbGetInt64 JsonbGetInt64Stringify JsonbGetPath JsonbGetPathStringify JsonbGetString JsonbGetStringStringify JsonbPretty JsonbStripNulls JsonbTypeof JustifyDays JustifyHours JustifyInterval KafkaMurmur2Bytes KafkaMurmur2String Left LikeEscape ListContainsList ListContainsListRev ListElementConcat ListLength ListLengthMax The list_length_max implementation. ListListConcat ListRemove Ln LnNumeric Log10 Log10Numeric LogBaseNumeric Lower Lt Lte MapBuildFromRecordList MapContainsAllKeys MapContainsAnyKeys MapContainsKey MapContainsMap MapGetValue MapLength ModFloat32 ModFloat64 ModInt16 ModInt32 ModInt64 ModNumeric ModUint16 ModUint32 ModUint64 MulFloat32 MulFloat64 MulInt16 MulInt32 MulInt64 MulInterval MulNumeric MulUint16 MulUint32 MulUint64 MzAclItemContainsPrivilege MzAclItemGrantee MzAclItemGrantor MzAclItemPrivileges MzFormatPrivileges MzRenderTypmod MzRowSize MzTypeName MzValidatePrivileges MzValidateRolePrivilege 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 ParseIdent PgColumnSize PgSizePretty Position Power PowerNumeric PrettySql QuoteIdent Radians RangeAdjacent RangeAfter RangeBefore RangeContainsDate RangeContainsDateRev RangeContainsI32 RangeContainsI64 RangeContainsI32Rev RangeContainsI64Rev RangeContainsNumeric RangeContainsNumericRev RangeContainsRange RangeContainsRangeRev RangeContainsTimestamp RangeContainsTimestampRev RangeContainsTimestampTz RangeContainsTimestampTzRev RangeDifference RangeEmpty RangeIntersection RangeLower RangeLowerInc RangeLowerInf RangeOverlaps RangeOverleft RangeOverright RangeUnion RangeUpper RangeUpperInc RangeUpperInf RecordGet RegexpMatch RegexpSplitToArray Reverse Right RoundFloat32 RoundFloat64 RoundNumeric RoundNumericBinary SeahashBytes SeahashString Sin Sinh Sleep SqrtFloat64 SqrtNumeric StartsWith StepMzTimestamp SubDate SubDateInterval SubFloat32 SubFloat64 SubInt16 SubInt32 SubInt64 SubInterval SubNumeric SubTime SubTimeInterval SubTimestamp SubTimestampInterval SubTimestampTz SubTimestampTzInterval SubUint16 SubUint32 SubUint64 Tan Tanh TextConcatBinary TimezoneOffset TimezoneTime TimezoneTimestamp TimezoneTimestampTz ToCharTimestamp ToCharTimestampFormat ToCharTimestampTz ToCharTimestampTzFormat ToTimestamp Trim TrimLeading TrimLeadingWhitespace TrimTrailing TrimTrailingWhitespace TrimWhitespace TruncFloat32 TruncFloat64 TruncNumeric TryParseMonotonicIso8601Timestamp Upper UuidGenerateV5 BinaryFunc UnaryFunc UnmaterializableFunc VariadicFunc MAX_STRING_FUNC_RESULT_BYTES The maximum size of the result strings of certain string functions, such as repeat and lpad.
Chosen to be the smallest number to keep our tests passing without changing. 100MiB is probably
higher than what we want, but it’s better than no limit. EagerUnaryFunc A description of an SQL unary function that operates on eagerly evaluated expressions LazyUnaryFunc A description of an SQL unary function that has the ability to lazy evaluate its arguments 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 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 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 normalize_with_form not 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 timezone tz.
For example, EST and 17:39:14 would return 12:39:14. timezone_timestamp Converts the timestamp dt, which is assumed to be in the time of the timezone tz to 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, EST and 2020-11-11T12:39:14 would return
2020-11-11T17:39:14Z. A DST observing timezone like America/New_York would cause the following DST anomalies:
2020-11-01T00:59:59 -> 2020-11-01T04:59:59Z and 2020-11-01T01:00:00 -> 2020-11-01T06:00:00Z
2020-03-08T02:59:59 -> 2020-03-08T07:59:59Z and 2020-03-08T03:00:00 -> 2020-03-08T07:00:00Z timezone_timestamptz Converts the UTC timestamptz utc to the local timestamp of the timezone tz.
For example, EST and 2020-11-11T17:39:14Z would return 2020-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