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 add_timestamp_months build_regex cast_jsonb_to_string cast_numeric_to_float32 cast_numeric_to_float64 cast_numeric_to_int16 cast_numeric_to_int32 cast_numeric_to_int64 constant_time_eq_bytes constant_time_eq_string date_bin date_part_interval_inner date_part_time_inner date_part_timestamp_inner date_trunc_inner extract_date_inner format_pg_legacy_char jsonb_stringify normalize_with_form 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.