Class Text<N>

Type Parameters

  • N extends number

Hierarchy (View Summary)

Constructors

constructor

Properties

nullability resultType serializeParamTypes v serializeParamTypes

Methods

!~ !~* !~~ !~~* @@ ^@ < <@ <= <> = > >= || ~ ~* ~<=~ ~<~ ~>=~ ~>~ ~~ ~~* anyValue anyValueTransfn arrayFill arrayPrepend asAggregate ascii binaryUpgradeAddSubRelState binaryUpgradeCreateEmptyExtension binaryUpgradeReploriginAdvance bitLength btrim bttextcmp bttextnamecmp bttextPatternCmp char characterLength charLength concat concatWs convertTo count cumeDist currentSetting currtid2 datePart dateTrunc decode denseRank elemContainedByMultirange elemContainedByRange execute extract firstValue format getClass ginCmpTslexeme ginCompareJsonb hasAnyColumnPrivilege hasColumnPrivilege hasDatabasePrivilege hasForeignDataWrapperPrivilege hasFunctionPrivilege hashtext hashtextextended hasLanguagePrivilege hasParameterPrivilege hasSchemaPrivilege hasSequencePrivilege hasServerPrivilege hasTablePrivilege hasTablespacePrivilege hasTypePrivilege initcap isNormalized jsonAgg jsonAggStrict jsonbAgg jsonbAggStrict jsonbBuildArray jsonbBuildObject jsonbObjectAgg jsonbObjectAggStrict jsonbObjectAggUnique jsonbObjectAggUniqueStrict jsonbPopulateRecord jsonbPopulateRecordset jsonbPopulateRecordValid jsonBuildArray jsonBuildObject jsonObjectAgg jsonObjectAggStrict jsonObjectAggUnique jsonObjectAggUniqueStrict jsonPopulateRecord jsonPopulateRecordset lag lastValue lead left length like likeEscape loImport lower lpad ltrim max md5 mode name normalize notlike nthValue numNonnulls numNulls octetLength overlay parseIdent percentRank pgBackupStart pgCollationFor pgColumnCompression pgColumnSize pgColumnToastChunkId pgCreateRestorePoint pgCurrentLogfile pgGetObjectAddress pgGetSerialSequence pgGetViewdef pgInputErrorInfo pgInputIsValid pgLsDir pgLsReplslotdir pgNotify pgReadBinaryFile pgReadFile pgReplicationOriginAdvance pgReplicationOriginCreate pgReplicationOriginDrop pgReplicationOriginOid pgReplicationOriginProgress pgReplicationOriginSessionSetup pgSettingsGetFlags pgSizeBytes pgSplitWalfileName pgStatFile pgStatGetProgressInfo pgStatGetReplicationSlot pgStatHaveStats pgStatResetReplicationSlot pgStatResetShared pgStatResetSlru pgTypeof phrasetoTsquery plaintoTsquery position queryToXml queryToXmlAndXmlschema queryToXmlschema quoteIdent quoteLiteral quoteNullable rank regclass regexpCount regexpInstr regexpLike regexpMatch regexpMatches regexpReplace regexpSplitToArray regexpSplitToTable regexpSubstr repeat replace reverse right rowSecurityActive rpad rtrim setConfig similarEscape similarToEscape splitPart startsWith stringAgg stringToArray stringToTable strpos substr substring textanycat textcat texteq texteqname textGe textgename textGt textgtname texticlike texticnlike texticregexeq texticregexne textLarger textLe textlen textlename textlike textLt textltname textne textnename textnlike textPatternGe textPatternGt textPatternLe textPatternLt textregexeq textregexne textSmaller timezone toAscii toDate toExpression toJson toJsonb toNumber toRegclass toRegcollation toRegnamespace toRegoper toRegoperator toRegproc toRegprocedure toRegrole toRegtype toRegtypemod toTimestamp toTsquery toTsvector translate tsDebug tsHeadline tsMatchTq tsMatchTt tsParse tsStat tsTokenType unicodeAssigned unistr upper websearchToTsquery widthBucket xml xmlcomment xmlexists xmlIsWellFormed xmlIsWellFormedContent xmlIsWellFormedDocument xmltext xpath xpathExists new parse subtype typeString

Constructors

constructor

  • new Text<N extends number>(v: unknown): Text<N>

    Type Parameters

    • N extends number

    Parameters

    • v: unknown

    Returns Text<N>

Properties

nullability

nullability: undefined | N = undefined

resultType

resultType: undefined | string = undefined

serializeParamTypes

serializeParamTypes: unknown = undefined

v

v: unknown

StaticserializeParamTypes

serializeParamTypes: undefined | readonly string[] = undefined

Methods

!~

  • "!~"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "!~"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "!~"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

!~*

  • "!~*"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "!~*"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "!~*"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

!~~

  • "!~~"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "!~~"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "!~~"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

!~~*

  • "!~~*"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "!~~*"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "!~~*"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

@@

  • "@@"(this: Text<1>, a1: Tsquery<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • "@@"(this: Text<0 | 1>, a1: Tsquery<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • "@@"(this: Text<number>, a1: Tsquery<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • "@@"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "@@"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "@@"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

^@

  • "^@"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "^@"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "^@"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

<

  • "<"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "<"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "<"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

  • "<"(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • "<"(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • "<"(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

<@

  • "<@"<T extends Any<unknown, number>>(this: T, a1: Anymultirange<1, T>): Bool<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<1>

  • "<@"<T extends Any<unknown, number>>(
        this: T,
        a1: Anymultirange<0 | 1, T>,
    ): Bool<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • "<@"<T extends Any<unknown, number>>(
        this: T,
        a1: Anymultirange<number, T>,
    ): Bool<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • "<@"<T extends Any<unknown, number>>(this: T, a1: Anyrange<1, T>): Bool<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<1>

  • "<@"<T extends Any<unknown, number>>(
        this: T,
        a1: Anyrange<0 | 1, T>,
    ): Bool<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • "<@"<T extends Any<unknown, number>>(
        this: T,
        a1: Anyrange<number, T>,
    ): Bool<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

<=

  • "<="(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "<="(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "<="(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

  • "<="(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • "<="(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • "<="(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

<>

  • "<>"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "<>"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "<>"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

  • "<>"(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • "<>"(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • "<>"(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

=

  • "="(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "="(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "="(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

  • "="(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • "="(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • "="(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

>

  • ">"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • ">"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • ">"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

  • ">"(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • ">"(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • ">"(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

>=

  • ">="(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • ">="(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • ">="(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

  • ">="(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • ">="(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • ">="(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

||

  • "||"<T extends Any<unknown, number>>(this: T, a1: Array<1, T>): Array<1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<1, T>

  • "||"<T extends Any<unknown, number>>(
        this: T,
        a1: Array<0 | 1, T>,
    ): Array<0 | 1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • "||"<T extends Any<unknown, number>>(
        this: T,
        a1: Array<number, T>,
    ): Array<0 | 1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

~

  • "~"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "~"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "~"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

~*

  • "~*"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "~*"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "~*"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

~<=~

  • "~<=~"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "~<=~"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "~<=~"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

~<~

  • "~<~"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "~<~"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "~<~"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

~>=~

  • "~>=~"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "~>=~"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "~>=~"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

~>~

  • "~>~"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "~>~"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "~>~"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

~~

  • "~~"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "~~"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "~~"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

~~*

  • "~~*"(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • "~~*"(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • "~~*"(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

anyValue

  • anyValue<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

anyValueTransfn

  • anyValueTransfn<T extends Any<unknown, number>>(this: T, a1: T | Input<T>): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • anyValueTransfn<T extends Any<unknown, number>>(this: T, a1: T | Input<T>): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • anyValueTransfn<T extends Any<unknown, number>>(this: T, a1: T | Input<T>): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

arrayFill

  • arrayFill<T extends Any<unknown, number>>(
        this: T,
        a1: Array<1, Int4<0 | 1>>,
    ): Array<1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<1, T>

  • arrayFill<T extends Any<unknown, number>>(
        this: T,
        a1: Array<0 | 1, Int4<0 | 1>>,
    ): Array<0 | 1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • arrayFill<T extends Any<unknown, number>>(
        this: T,
        a1: Array<number, Int4<0 | 1>>,
    ): Array<0 | 1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • arrayFill<T extends Any<unknown, number>>(
        this: T,
        a1: Array<1, Int4<0 | 1>>,
        a2: Array<1, Int4<0 | 1>>,
    ): Array<1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<1, T>

  • arrayFill<T extends Any<unknown, number>>(
        this: T,
        a1: Array<0 | 1, Int4<0 | 1>>,
        a2: Array<0 | 1, Int4<0 | 1>>,
    ): Array<0 | 1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • arrayFill<T extends Any<unknown, number>>(
        this: T,
        a1: Array<number, Int4<0 | 1>>,
        a2: Array<number, Int4<0 | 1>>,
    ): Array<0 | 1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

arrayPrepend

  • arrayPrepend<T extends Any<unknown, number>>(
        this: T,
        a1: Array<1, T>,
    ): Array<1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<1, T>

  • arrayPrepend<T extends Any<unknown, number>>(
        this: T,
        a1: Array<0 | 1, T>,
    ): Array<0 | 1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • arrayPrepend<T extends Any<unknown, number>>(
        this: T,
        a1: Array<number, T>,
    ): Array<0 | 1, T>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

asAggregate

  • asAggregate(): undefined | Text<number>

    Returns undefined | Text<number>

ascii

  • ascii(this: Text<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • ascii(this: Text<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • ascii(this: Text<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

binaryUpgradeAddSubRelState

  • binaryUpgradeAddSubRelState(
        this: Text<1>,
        a1: Oid<1>,
        a2: Char<1>,
        a3: PgLsn<1>,
    ): Void<1>

    Parameters

    Returns Void<1>

  • binaryUpgradeAddSubRelState(
        this: Text<0 | 1>,
        a1: Oid<0 | 1>,
        a2: Char<0 | 1>,
        a3: PgLsn<0 | 1>,
    ): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

  • binaryUpgradeAddSubRelState(
        this: Text<number>,
        a1: Oid<number>,
        a2: Char<number>,
        a3: PgLsn<number>,
    ): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

binaryUpgradeCreateEmptyExtension

  • binaryUpgradeCreateEmptyExtension(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | boolean | Bool<1>,
        a3: undefined | string | Text<1>,
        a4: Array<1, Oid<0 | 1>>,
        a5: Array<1, Text<0 | 1>>,
        a6: Array<1, Text<0 | 1>>,
    ): Void<1>

    Parameters

    Returns Void<1>

  • binaryUpgradeCreateEmptyExtension(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | boolean | Bool<0 | 1>,
        a3: undefined | string | Text<0 | 1>,
        a4: Array<0 | 1, Oid<0 | 1>>,
        a5: Array<0 | 1, Text<0 | 1>>,
        a6: Array<0 | 1, Text<0 | 1>>,
    ): Void<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | boolean | Bool<0 | 1>
    • a3: undefined | string | Text<0 | 1>
    • a4: Array<0 | 1, Oid<0 | 1>>
    • a5: Array<0 | 1, Text<0 | 1>>
    • a6: Array<0 | 1, Text<0 | 1>>

    Returns Void<0 | 1>

  • binaryUpgradeCreateEmptyExtension(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | boolean | Bool<number>,
        a3: undefined | string | Text<number>,
        a4: Array<number, Oid<0 | 1>>,
        a5: Array<number, Text<0 | 1>>,
        a6: Array<number, Text<0 | 1>>,
    ): Void<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | boolean | Bool<number>
    • a3: undefined | string | Text<number>
    • a4: Array<number, Oid<0 | 1>>
    • a5: Array<number, Text<0 | 1>>
    • a6: Array<number, Text<0 | 1>>

    Returns Void<0 | 1>

binaryUpgradeReploriginAdvance

  • binaryUpgradeReploriginAdvance(this: Text<1>, a1: PgLsn<1>): Void<1>

    Parameters

    Returns Void<1>

  • binaryUpgradeReploriginAdvance(this: Text<0 | 1>, a1: PgLsn<0 | 1>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

  • binaryUpgradeReploriginAdvance(
        this: Text<number>,
        a1: PgLsn<number>,
    ): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

bitLength

  • bitLength(this: Text<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • bitLength(this: Text<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • bitLength(this: Text<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

btrim

  • btrim(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • btrim(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • btrim(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • btrim(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • btrim(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • btrim(this: Text<number>, a1: undefined | string | Text<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

bttextcmp

  • bttextcmp(this: Text<1>, a1: undefined | string | Text<1>): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Int4<1>

  • bttextcmp(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Int4<0 | 1>

  • bttextcmp(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Int4<0 | 1>

bttextnamecmp

  • bttextnamecmp(this: Text<1>, a1: Name<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • bttextnamecmp(this: Text<0 | 1>, a1: Name<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • bttextnamecmp(this: Text<number>, a1: Name<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

bttextPatternCmp

  • bttextPatternCmp(this: Text<1>, a1: undefined | string | Text<1>): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Int4<1>

  • bttextPatternCmp(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Int4<0 | 1>

  • bttextPatternCmp(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Int4<0 | 1>

char

  • char(this: Text<1>): Char<1>

    Parameters

    Returns Char<1>

  • char(this: Text<0 | 1>): Char<0 | 1>

    Parameters

    Returns Char<0 | 1>

  • char(this: Text<number>): Char<0 | 1>

    Parameters

    Returns Char<0 | 1>

characterLength

  • characterLength(this: Text<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • characterLength(this: Text<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • characterLength(this: Text<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

charLength

  • charLength(this: Text<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • charLength(this: Text<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • charLength(this: Text<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

concat

  • concat<T extends Any<unknown, number>>(this: T): Text<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<1>

  • concat<T extends Any<unknown, number>>(this: T): Text<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • concat<T extends Any<unknown, number>>(this: T): Text<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

concatWs

  • concatWs(this: Text<1>, a1: Any<1>): Text<1>

    Parameters

    Returns Text<1>

  • concatWs(this: Text<0 | 1>, a1: Any<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • concatWs(this: Text<number>, a1: Any<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

convertTo

  • convertTo(this: Text<1>, a1: Name<1>): Bytea<1>

    Parameters

    Returns Bytea<1>

  • convertTo(this: Text<0 | 1>, a1: Name<0 | 1>): Bytea<0 | 1>

    Parameters

    Returns Bytea<0 | 1>

  • convertTo(this: Text<number>, a1: Name<number>): Bytea<0 | 1>

    Parameters

    Returns Bytea<0 | 1>

count

  • count<T extends Any<unknown, number>>(this: T): Int8<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int8<1>

cumeDist

  • cumeDist<T extends Any<unknown, number>>(this: T): Float8<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Float8<0 | 1>

currentSetting

  • currentSetting(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • currentSetting(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • currentSetting(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • currentSetting(this: Text<1>, a1: undefined | boolean | Bool<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>

    Returns Text<1>

  • currentSetting(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>

    Returns Text<0 | 1>

  • currentSetting(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>

    Returns Text<0 | 1>

currtid2

  • currtid2(this: Text<1>, a1: Tid<1>): Tid<1>

    Parameters

    Returns Tid<1>

  • currtid2(this: Text<0 | 1>, a1: Tid<0 | 1>): Tid<0 | 1>

    Parameters

    Returns Tid<0 | 1>

  • currtid2(this: Text<number>, a1: Tid<number>): Tid<0 | 1>

    Parameters

    Returns Tid<0 | 1>

datePart

dateTrunc

decode

  • decode(this: Text<1>, a1: undefined | string | Text<1>): Bytea<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bytea<1>

  • decode(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bytea<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bytea<0 | 1>

  • decode(this: Text<number>, a1: undefined | string | Text<number>): Bytea<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bytea<0 | 1>

denseRank

  • denseRank<T extends Any<unknown, number>>(this: T): Int8<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int8<0 | 1>

elemContainedByMultirange

elemContainedByRange

  • elemContainedByRange<T extends Any<unknown, number>>(
        this: T,
        a1: Anyrange<1, T>,
    ): Bool<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<1>

  • elemContainedByRange<T extends Any<unknown, number>>(
        this: T,
        a1: Anyrange<0 | 1, T>,
    ): Bool<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • elemContainedByRange<T extends Any<unknown, number>>(
        this: T,
        a1: Anyrange<number, T>,
    ): Bool<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

execute

  • execute(
        db: Typegres,
    ): {
        then(
            resolve: (
                result: N extends 0 ? null : N extends 1 ? string : null | string,
            ) => void,
            reject: (err: unknown) => void,
        ): void;
    }

    Parameters

    • db: Typegres

    Returns {
        then(
            resolve: (
                result: N extends 0 ? null : N extends 1 ? string : null | string,
            ) => void,
            reject: (err: unknown) => void,
        ): void;
    }

extract

firstValue

  • firstValue<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • firstValue<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • firstValue<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

format

  • format(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • format(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • format(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • format(this: Text<1>, a1: Any<1>): Text<1>

    Parameters

    Returns Text<1>

  • format(this: Text<0 | 1>, a1: Any<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • format(this: Text<number>, a1: Any<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

getClass

  • getClass(this: this): typeof Any

    Parameters

    • this: this

    Returns typeof Any

ginCmpTslexeme

  • ginCmpTslexeme(this: Text<1>, a1: undefined | string | Text<1>): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Int4<1>

  • ginCmpTslexeme(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Int4<0 | 1>

  • ginCmpTslexeme(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Int4<0 | 1>

ginCompareJsonb

  • ginCompareJsonb(this: Text<1>, a1: undefined | string | Text<1>): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Int4<1>

  • ginCompareJsonb(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Int4<0 | 1>

  • ginCompareJsonb(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Int4<0 | 1>

hasAnyColumnPrivilege

  • hasAnyColumnPrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasAnyColumnPrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasAnyColumnPrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasColumnPrivilege

  • hasColumnPrivilege(
        this: Text<1>,
        a1: undefined | number | Int2<1>,
        a2: undefined | string | Text<1>,
    ): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int2<1>
    • a2: undefined | string | Text<1>

    Returns Bool<1>

  • hasColumnPrivilege(
        this: Text<0 | 1>,
        a1: undefined | number | Int2<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int2<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasColumnPrivilege(
        this: Text<number>,
        a1: undefined | number | Int2<number>,
        a2: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int2<number>
    • a2: undefined | string | Text<number>

    Returns Bool<0 | 1>

  • hasColumnPrivilege(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Bool<1>

  • hasColumnPrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasColumnPrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasDatabasePrivilege

  • hasDatabasePrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasDatabasePrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasDatabasePrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasForeignDataWrapperPrivilege

  • hasForeignDataWrapperPrivilege(
        this: Text<1>,
        a1: undefined | string | Text<1>,
    ): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasForeignDataWrapperPrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasForeignDataWrapperPrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasFunctionPrivilege

  • hasFunctionPrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasFunctionPrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasFunctionPrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hashtext

  • hashtext(this: Text<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • hashtext(this: Text<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • hashtext(this: Text<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

hashtextextended

  • hashtextextended(this: Text<1>, a1: undefined | bigint | Int8<1>): Int8<1>

    Parameters

    • this: Text<1>
    • a1: undefined | bigint | Int8<1>

    Returns Int8<1>

  • hashtextextended(
        this: Text<0 | 1>,
        a1: undefined | bigint | Int8<0 | 1>,
    ): Int8<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | bigint | Int8<0 | 1>

    Returns Int8<0 | 1>

  • hashtextextended(
        this: Text<number>,
        a1: undefined | bigint | Int8<number>,
    ): Int8<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | bigint | Int8<number>

    Returns Int8<0 | 1>

hasLanguagePrivilege

  • hasLanguagePrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasLanguagePrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasLanguagePrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasParameterPrivilege

  • hasParameterPrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasParameterPrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasParameterPrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasSchemaPrivilege

  • hasSchemaPrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasSchemaPrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasSchemaPrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasSequencePrivilege

  • hasSequencePrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasSequencePrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasSequencePrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasServerPrivilege

  • hasServerPrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasServerPrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasServerPrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasTablePrivilege

  • hasTablePrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasTablePrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasTablePrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasTablespacePrivilege

  • hasTablespacePrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasTablespacePrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasTablespacePrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

hasTypePrivilege

  • hasTypePrivilege(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • hasTypePrivilege(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • hasTypePrivilege(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

initcap

  • initcap(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • initcap(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • initcap(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

isNormalized

  • isNormalized(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • isNormalized(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • isNormalized(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

jsonAgg

  • jsonAgg<T extends Any<unknown, number>>(this: T): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

jsonAggStrict

  • jsonAggStrict<T extends Any<unknown, number>>(this: T): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

jsonbAgg

  • jsonbAgg<T extends Any<unknown, number>>(this: T): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

jsonbAggStrict

  • jsonbAggStrict<T extends Any<unknown, number>>(this: T): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

jsonbBuildArray

  • jsonbBuildArray<T extends Any<unknown, number>>(this: T): Jsonb<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<1>

  • jsonbBuildArray<T extends Any<unknown, number>>(this: T): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

  • jsonbBuildArray<T extends Any<unknown, number>>(this: T): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

jsonbBuildObject

  • jsonbBuildObject<T extends Any<unknown, number>>(this: T): Jsonb<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<1>

  • jsonbBuildObject<T extends Any<unknown, number>>(this: T): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

  • jsonbBuildObject<T extends Any<unknown, number>>(this: T): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

jsonbObjectAgg

  • jsonbObjectAgg<T extends Any<unknown, number>>(
        this: T,
        a1: Any<number>,
    ): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<number>

    Returns Jsonb<0 | 1>

jsonbObjectAggStrict

  • jsonbObjectAggStrict<T extends Any<unknown, number>>(
        this: T,
        a1: Any<number>,
    ): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<number>

    Returns Jsonb<0 | 1>

jsonbObjectAggUnique

  • jsonbObjectAggUnique<T extends Any<unknown, number>>(
        this: T,
        a1: Any<number>,
    ): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<number>

    Returns Jsonb<0 | 1>

jsonbObjectAggUniqueStrict

  • jsonbObjectAggUniqueStrict<T extends Any<unknown, number>>(
        this: T,
        a1: Any<number>,
    ): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<number>

    Returns Jsonb<0 | 1>

jsonbPopulateRecord

  • jsonbPopulateRecord<T extends Any<unknown, number>>(this: T, a1: Jsonb<1>): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • jsonbPopulateRecord<T extends Any<unknown, number>>(
        this: T,
        a1: Jsonb<0 | 1>,
    ): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • jsonbPopulateRecord<T extends Any<unknown, number>>(
        this: T,
        a1: Jsonb<number>,
    ): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

jsonbPopulateRecordset

  • jsonbPopulateRecordset<T extends Any<unknown, number>>(
        this: T,
        a1: Jsonb<1>,
    ): Setof<{ from: {} }>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Setof<{ from: {} }>

  • jsonbPopulateRecordset<T extends Any<unknown, number>>(
        this: T,
        a1: Jsonb<0 | 1>,
    ): Setof<{ from: {} }>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Setof<{ from: {} }>

  • jsonbPopulateRecordset<T extends Any<unknown, number>>(
        this: T,
        a1: Jsonb<number>,
    ): Setof<{ from: {} }>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Setof<{ from: {} }>

jsonbPopulateRecordValid

  • jsonbPopulateRecordValid<T extends Any<unknown, number>>(
        this: T,
        a1: Jsonb<1>,
    ): Bool<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<1>

  • jsonbPopulateRecordValid<T extends Any<unknown, number>>(
        this: T,
        a1: Jsonb<0 | 1>,
    ): Bool<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • jsonbPopulateRecordValid<T extends Any<unknown, number>>(
        this: T,
        a1: Jsonb<number>,
    ): Bool<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

jsonBuildArray

  • jsonBuildArray<T extends Any<unknown, number>>(this: T): Json<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<1>

  • jsonBuildArray<T extends Any<unknown, number>>(this: T): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

  • jsonBuildArray<T extends Any<unknown, number>>(this: T): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

jsonBuildObject

  • jsonBuildObject<T extends Any<unknown, number>>(this: T): Json<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<1>

  • jsonBuildObject<T extends Any<unknown, number>>(this: T): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

  • jsonBuildObject<T extends Any<unknown, number>>(this: T): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

jsonObjectAgg

  • jsonObjectAgg<T extends Any<unknown, number>>(
        this: T,
        a1: Any<number>,
    ): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<number>

    Returns Json<0 | 1>

jsonObjectAggStrict

  • jsonObjectAggStrict<T extends Any<unknown, number>>(
        this: T,
        a1: Any<number>,
    ): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<number>

    Returns Json<0 | 1>

jsonObjectAggUnique

  • jsonObjectAggUnique<T extends Any<unknown, number>>(
        this: T,
        a1: Any<number>,
    ): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<number>

    Returns Json<0 | 1>

jsonObjectAggUniqueStrict

  • jsonObjectAggUniqueStrict<T extends Any<unknown, number>>(
        this: T,
        a1: Any<number>,
    ): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<number>

    Returns Json<0 | 1>

jsonPopulateRecord

  • jsonPopulateRecord<T extends Any<unknown, number>>(
        this: T,
        a1: Json<1>,
        a2: undefined | boolean | Bool<1>,
    ): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Json<1>
    • a2: undefined | boolean | Bool<1>

    Returns T

  • jsonPopulateRecord<T extends Any<unknown, number>>(
        this: T,
        a1: Json<0 | 1>,
        a2: undefined | boolean | Bool<0 | 1>,
    ): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Json<0 | 1>
    • a2: undefined | boolean | Bool<0 | 1>

    Returns T

  • jsonPopulateRecord<T extends Any<unknown, number>>(
        this: T,
        a1: Json<number>,
        a2: undefined | boolean | Bool<number>,
    ): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Json<number>
    • a2: undefined | boolean | Bool<number>

    Returns T

jsonPopulateRecordset

  • jsonPopulateRecordset<T extends Any<unknown, number>>(
        this: T,
        a1: Json<1>,
        a2: undefined | boolean | Bool<1>,
    ): Setof<{ from: {} }>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Json<1>
    • a2: undefined | boolean | Bool<1>

    Returns Setof<{ from: {} }>

  • jsonPopulateRecordset<T extends Any<unknown, number>>(
        this: T,
        a1: Json<0 | 1>,
        a2: undefined | boolean | Bool<0 | 1>,
    ): Setof<{ from: {} }>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Json<0 | 1>
    • a2: undefined | boolean | Bool<0 | 1>

    Returns Setof<{ from: {} }>

  • jsonPopulateRecordset<T extends Any<unknown, number>>(
        this: T,
        a1: Json<number>,
        a2: undefined | boolean | Bool<number>,
    ): Setof<{ from: {} }>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Json<number>
    • a2: undefined | boolean | Bool<number>

    Returns Setof<{ from: {} }>

lag

  • lag<T extends Any<unknown, number>>(this: T, a1: Int4<1>, a2: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • lag<T extends Any<unknown, number>>(this: T, a1: Int4<0 | 1>, a2: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • lag<T extends Any<unknown, number>>(this: T, a1: Int4<number>, a2: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • lag<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • lag<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • lag<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • lag<T extends Any<unknown, number>>(this: T, a1: Int4<1>): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • lag<T extends Any<unknown, number>>(this: T, a1: Int4<0 | 1>): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • lag<T extends Any<unknown, number>>(this: T, a1: Int4<number>): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

lastValue

  • lastValue<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • lastValue<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • lastValue<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

lead

  • lead<T extends Any<unknown, number>>(this: T, a1: Int4<1>, a2: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • lead<T extends Any<unknown, number>>(this: T, a1: Int4<0 | 1>, a2: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • lead<T extends Any<unknown, number>>(this: T, a1: Int4<number>, a2: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • lead<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • lead<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • lead<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • lead<T extends Any<unknown, number>>(this: T, a1: Int4<1>): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • lead<T extends Any<unknown, number>>(this: T, a1: Int4<0 | 1>): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • lead<T extends Any<unknown, number>>(this: T, a1: Int4<number>): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

left

  • left(this: Text<1>, a1: undefined | number | Int4<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>

    Returns Text<1>

  • left(this: Text<0 | 1>, a1: undefined | number | Int4<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • left(this: Text<number>, a1: undefined | number | Int4<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>

    Returns Text<0 | 1>

length

  • length(this: Text<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • length(this: Text<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • length(this: Text<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

like

  • like(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • like(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • like(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

likeEscape

  • likeEscape(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • likeEscape(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • likeEscape(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

loImport

  • loImport(this: Text<1>): Oid<1>

    Parameters

    Returns Oid<1>

  • loImport(this: Text<0 | 1>): Oid<0 | 1>

    Parameters

    Returns Oid<0 | 1>

  • loImport(this: Text<number>): Oid<0 | 1>

    Parameters

    Returns Oid<0 | 1>

  • loImport(this: Text<1>, a1: Oid<1>): Oid<1>

    Parameters

    Returns Oid<1>

  • loImport(this: Text<0 | 1>, a1: Oid<0 | 1>): Oid<0 | 1>

    Parameters

    Returns Oid<0 | 1>

  • loImport(this: Text<number>, a1: Oid<number>): Oid<0 | 1>

    Parameters

    Returns Oid<0 | 1>

lower

  • lower(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • lower(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • lower(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

lpad

  • lpad(this: Text<1>, a1: undefined | number | Int4<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>

    Returns Text<1>

  • lpad(this: Text<0 | 1>, a1: undefined | number | Int4<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • lpad(this: Text<number>, a1: undefined | number | Int4<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • lpad(
        this: Text<1>,
        a1: undefined | number | Int4<1>,
        a2: undefined | string | Text<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>
    • a2: undefined | string | Text<1>

    Returns Text<1>

  • lpad(
        this: Text<0 | 1>,
        a1: undefined | number | Int4<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • lpad(
        this: Text<number>,
        a1: undefined | number | Int4<number>,
        a2: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>
    • a2: undefined | string | Text<number>

    Returns Text<0 | 1>

ltrim

  • ltrim(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • ltrim(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • ltrim(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • ltrim(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • ltrim(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • ltrim(this: Text<number>, a1: undefined | string | Text<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

max

  • max(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

md5

  • md5(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • md5(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • md5(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

mode

  • mode<T extends Any<unknown, number>>(this: T): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

name

  • name(this: Text<1>): Name<1>

    Parameters

    Returns Name<1>

  • name(this: Text<0 | 1>): Name<0 | 1>

    Parameters

    Returns Name<0 | 1>

  • name(this: Text<number>): Name<0 | 1>

    Parameters

    Returns Name<0 | 1>

normalize

  • normalize(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • normalize(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • normalize(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

notlike

  • notlike(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • notlike(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • notlike(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

nthValue

  • nthValue<T extends Any<unknown, number>>(
        this: T,
        a1: undefined | number | Int4<1>,
    ): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: undefined | number | Int4<1>

    Returns T

  • nthValue<T extends Any<unknown, number>>(
        this: T,
        a1: undefined | number | Int4<0 | 1>,
    ): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: undefined | number | Int4<0 | 1>

    Returns T

  • nthValue<T extends Any<unknown, number>>(
        this: T,
        a1: undefined | number | Int4<number>,
    ): T

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: undefined | number | Int4<number>

    Returns T

numNonnulls

  • numNonnulls<T extends Any<unknown, number>>(this: T): Int4<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<1>

  • numNonnulls<T extends Any<unknown, number>>(this: T): Int4<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<0 | 1>

  • numNonnulls<T extends Any<unknown, number>>(this: T): Int4<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<0 | 1>

numNulls

  • numNulls<T extends Any<unknown, number>>(this: T): Int4<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<1>

  • numNulls<T extends Any<unknown, number>>(this: T): Int4<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<0 | 1>

  • numNulls<T extends Any<unknown, number>>(this: T): Int4<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<0 | 1>

octetLength

  • octetLength(this: Text<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • octetLength(this: Text<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • octetLength(this: Text<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

overlay

  • overlay(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>

    Returns Text<1>

  • overlay(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • overlay(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • overlay(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
        a3: undefined | number | Int4<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>
    • a3: undefined | number | Int4<1>

    Returns Text<1>

  • overlay(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>
    • a3: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • overlay(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
        a3: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>
    • a3: undefined | number | Int4<number>

    Returns Text<0 | 1>

parseIdent

  • parseIdent(
        this: Text<1>,
        a1: undefined | boolean | Bool<1>,
    ): Array<1, Text<0 | 1>>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>

    Returns Array<1, Text<0 | 1>>

  • parseIdent(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>

    Returns Array<0 | 1, Text<0 | 1>>

  • parseIdent(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>

    Returns Array<0 | 1, Text<0 | 1>>

percentRank

  • percentRank<T extends Any<unknown, number>>(this: T): Float8<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Float8<0 | 1>

pgBackupStart

  • pgBackupStart(this: Text<1>, a1: undefined | boolean | Bool<1>): PgLsn<1>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>

    Returns PgLsn<1>

  • pgBackupStart(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
    ): PgLsn<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>

    Returns PgLsn<0 | 1>

  • pgBackupStart(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
    ): PgLsn<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>

    Returns PgLsn<0 | 1>

pgCollationFor

  • pgCollationFor<T extends Any<unknown, number>>(this: T): Text<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<1>

  • pgCollationFor<T extends Any<unknown, number>>(this: T): Text<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • pgCollationFor<T extends Any<unknown, number>>(this: T): Text<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

pgColumnCompression

  • pgColumnCompression<T extends Any<unknown, number>>(this: T): Text<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<1>

  • pgColumnCompression<T extends Any<unknown, number>>(this: T): Text<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • pgColumnCompression<T extends Any<unknown, number>>(this: T): Text<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

pgColumnSize

  • pgColumnSize<T extends Any<unknown, number>>(this: T): Int4<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<1>

  • pgColumnSize<T extends Any<unknown, number>>(this: T): Int4<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<0 | 1>

  • pgColumnSize<T extends Any<unknown, number>>(this: T): Int4<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<0 | 1>

pgColumnToastChunkId

  • pgColumnToastChunkId<T extends Any<unknown, number>>(this: T): Oid<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Oid<1>

  • pgColumnToastChunkId<T extends Any<unknown, number>>(this: T): Oid<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Oid<0 | 1>

  • pgColumnToastChunkId<T extends Any<unknown, number>>(this: T): Oid<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Oid<0 | 1>

pgCreateRestorePoint

  • pgCreateRestorePoint(this: Text<1>): PgLsn<1>

    Parameters

    Returns PgLsn<1>

  • pgCreateRestorePoint(this: Text<0 | 1>): PgLsn<0 | 1>

    Parameters

    Returns PgLsn<0 | 1>

  • pgCreateRestorePoint(this: Text<number>): PgLsn<0 | 1>

    Parameters

    Returns PgLsn<0 | 1>

pgCurrentLogfile

  • pgCurrentLogfile(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • pgCurrentLogfile(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • pgCurrentLogfile(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

pgGetObjectAddress

  • pgGetObjectAddress(
        this: Text<1>,
        a1: Array<1, Text<0 | 1>>,
        a2: Array<1, Text<0 | 1>>,
    ): Record<1, { classid: Oid<1>; objid: Oid<1>; objsubid: Int4<1> }>

    Parameters

    Returns Record<1, { classid: Oid<1>; objid: Oid<1>; objsubid: Int4<1> }>

  • pgGetObjectAddress(
        this: Text<0 | 1>,
        a1: Array<0 | 1, Text<0 | 1>>,
        a2: Array<0 | 1, Text<0 | 1>>,
    ): Record<
        0
        | 1,
        { classid: Oid<0 | 1>; objid: Oid<0 | 1>; objsubid: Int4<0 | 1> },
    >

    Parameters

    Returns Record<0 | 1, { classid: Oid<0 | 1>; objid: Oid<0 | 1>; objsubid: Int4<0 | 1> }>

  • pgGetObjectAddress(
        this: Text<number>,
        a1: Array<number, Text<0 | 1>>,
        a2: Array<number, Text<0 | 1>>,
    ): Record<
        0
        | 1,
        { classid: Oid<0 | 1>; objid: Oid<0 | 1>; objsubid: Int4<0 | 1> },
    >

    Parameters

    Returns Record<0 | 1, { classid: Oid<0 | 1>; objid: Oid<0 | 1>; objsubid: Int4<0 | 1> }>

pgGetSerialSequence

  • pgGetSerialSequence(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • pgGetSerialSequence(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • pgGetSerialSequence(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

pgGetViewdef

  • pgGetViewdef(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • pgGetViewdef(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • pgGetViewdef(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • pgGetViewdef(this: Text<1>, a1: undefined | boolean | Bool<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>

    Returns Text<1>

  • pgGetViewdef(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>

    Returns Text<0 | 1>

  • pgGetViewdef(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>

    Returns Text<0 | 1>

pgInputErrorInfo

  • pgInputErrorInfo(
        this: Text<1>,
        a1: undefined | string | Text<1>,
    ): Record<
        1,
        {
            detail: Text<1>;
            hint: Text<1>;
            message: Text<1>;
            sql_error_code: Text<1>;
        },
    >

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Record<
        1,
        {
            detail: Text<1>;
            hint: Text<1>;
            message: Text<1>;
            sql_error_code: Text<1>;
        },
    >

  • pgInputErrorInfo(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Record<
        0
        | 1,
        {
            detail: Text<0 | 1>;
            hint: Text<0 | 1>;
            message: Text<0 | 1>;
            sql_error_code: Text<0 | 1>;
        },
    >

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Record<
        0
        | 1,
        {
            detail: Text<0 | 1>;
            hint: Text<0 | 1>;
            message: Text<0 | 1>;
            sql_error_code: Text<0 | 1>;
        },
    >

  • pgInputErrorInfo(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Record<
        0
        | 1,
        {
            detail: Text<0 | 1>;
            hint: Text<0 | 1>;
            message: Text<0 | 1>;
            sql_error_code: Text<0 | 1>;
        },
    >

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Record<
        0
        | 1,
        {
            detail: Text<0 | 1>;
            hint: Text<0 | 1>;
            message: Text<0 | 1>;
            sql_error_code: Text<0 | 1>;
        },
    >

pgInputIsValid

  • pgInputIsValid(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • pgInputIsValid(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • pgInputIsValid(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

pgLsDir

  • pgLsDir(this: Text<1>): Setof<{ from: {} }>

    Parameters

    Returns Setof<{ from: {} }>

  • pgLsDir(this: Text<0 | 1>): Setof<{ from: {} }>

    Parameters

    Returns Setof<{ from: {} }>

  • pgLsDir(this: Text<number>): Setof<{ from: {} }>

    Parameters

    Returns Setof<{ from: {} }>

  • pgLsDir(
        this: Text<1>,
        a1: undefined | boolean | Bool<1>,
        a2: undefined | boolean | Bool<1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>
    • a2: undefined | boolean | Bool<1>

    Returns Setof<{ from: {} }>

  • pgLsDir(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
        a2: undefined | boolean | Bool<0 | 1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>
    • a2: undefined | boolean | Bool<0 | 1>

    Returns Setof<{ from: {} }>

  • pgLsDir(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
        a2: undefined | boolean | Bool<number>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>
    • a2: undefined | boolean | Bool<number>

    Returns Setof<{ from: {} }>

pgLsReplslotdir

  • pgLsReplslotdir(
        this: Text<1>,
    ): Setof<
        { from: { modification: Timestamptz<1>; name: Text<1>; size: Int8<1> } },
    >

    Parameters

    Returns Setof<{ from: { modification: Timestamptz<1>; name: Text<1>; size: Int8<1> } }>

  • pgLsReplslotdir(
        this: Text<0 | 1>,
    ): Setof<
        {
            from: {
                modification: Timestamptz<0 | 1>;
                name: Text<0 | 1>;
                size: Int8<0 | 1>;
            };
        },
    >

    Parameters

    Returns Setof<
        {
            from: {
                modification: Timestamptz<0 | 1>;
                name: Text<0 | 1>;
                size: Int8<0 | 1>;
            };
        },
    >

  • pgLsReplslotdir(
        this: Text<number>,
    ): Setof<
        {
            from: {
                modification: Timestamptz<0 | 1>;
                name: Text<0 | 1>;
                size: Int8<0 | 1>;
            };
        },
    >

    Parameters

    Returns Setof<
        {
            from: {
                modification: Timestamptz<0 | 1>;
                name: Text<0 | 1>;
                size: Int8<0 | 1>;
            };
        },
    >

pgNotify

  • pgNotify(this: Text<1>, a1: undefined | string | Text<1>): Void<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Void<1>

  • pgNotify(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Void<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Void<0 | 1>

  • pgNotify(this: Text<number>, a1: undefined | string | Text<number>): Void<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Void<0 | 1>

pgReadBinaryFile

  • pgReadBinaryFile(this: Text<1>): Bytea<1>

    Parameters

    Returns Bytea<1>

  • pgReadBinaryFile(this: Text<0 | 1>): Bytea<0 | 1>

    Parameters

    Returns Bytea<0 | 1>

  • pgReadBinaryFile(this: Text<number>): Bytea<0 | 1>

    Parameters

    Returns Bytea<0 | 1>

  • pgReadBinaryFile(this: Text<1>, a1: undefined | boolean | Bool<1>): Bytea<1>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>

    Returns Bytea<1>

  • pgReadBinaryFile(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
    ): Bytea<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>

    Returns Bytea<0 | 1>

  • pgReadBinaryFile(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
    ): Bytea<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>

    Returns Bytea<0 | 1>

  • pgReadBinaryFile(
        this: Text<1>,
        a1: undefined | bigint | Int8<1>,
        a2: undefined | bigint | Int8<1>,
    ): Bytea<1>

    Parameters

    • this: Text<1>
    • a1: undefined | bigint | Int8<1>
    • a2: undefined | bigint | Int8<1>

    Returns Bytea<1>

  • pgReadBinaryFile(
        this: Text<0 | 1>,
        a1: undefined | bigint | Int8<0 | 1>,
        a2: undefined | bigint | Int8<0 | 1>,
    ): Bytea<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | bigint | Int8<0 | 1>
    • a2: undefined | bigint | Int8<0 | 1>

    Returns Bytea<0 | 1>

  • pgReadBinaryFile(
        this: Text<number>,
        a1: undefined | bigint | Int8<number>,
        a2: undefined | bigint | Int8<number>,
    ): Bytea<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | bigint | Int8<number>
    • a2: undefined | bigint | Int8<number>

    Returns Bytea<0 | 1>

  • pgReadBinaryFile(
        this: Text<1>,
        a1: undefined | bigint | Int8<1>,
        a2: undefined | bigint | Int8<1>,
        a3: undefined | boolean | Bool<1>,
    ): Bytea<1>

    Parameters

    • this: Text<1>
    • a1: undefined | bigint | Int8<1>
    • a2: undefined | bigint | Int8<1>
    • a3: undefined | boolean | Bool<1>

    Returns Bytea<1>

  • pgReadBinaryFile(
        this: Text<0 | 1>,
        a1: undefined | bigint | Int8<0 | 1>,
        a2: undefined | bigint | Int8<0 | 1>,
        a3: undefined | boolean | Bool<0 | 1>,
    ): Bytea<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | bigint | Int8<0 | 1>
    • a2: undefined | bigint | Int8<0 | 1>
    • a3: undefined | boolean | Bool<0 | 1>

    Returns Bytea<0 | 1>

  • pgReadBinaryFile(
        this: Text<number>,
        a1: undefined | bigint | Int8<number>,
        a2: undefined | bigint | Int8<number>,
        a3: undefined | boolean | Bool<number>,
    ): Bytea<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | bigint | Int8<number>
    • a2: undefined | bigint | Int8<number>
    • a3: undefined | boolean | Bool<number>

    Returns Bytea<0 | 1>

pgReadFile

  • pgReadFile(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • pgReadFile(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • pgReadFile(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • pgReadFile(this: Text<1>, a1: undefined | boolean | Bool<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>

    Returns Text<1>

  • pgReadFile(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>

    Returns Text<0 | 1>

  • pgReadFile(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>

    Returns Text<0 | 1>

  • pgReadFile(
        this: Text<1>,
        a1: undefined | bigint | Int8<1>,
        a2: undefined | bigint | Int8<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | bigint | Int8<1>
    • a2: undefined | bigint | Int8<1>

    Returns Text<1>

  • pgReadFile(
        this: Text<0 | 1>,
        a1: undefined | bigint | Int8<0 | 1>,
        a2: undefined | bigint | Int8<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | bigint | Int8<0 | 1>
    • a2: undefined | bigint | Int8<0 | 1>

    Returns Text<0 | 1>

  • pgReadFile(
        this: Text<number>,
        a1: undefined | bigint | Int8<number>,
        a2: undefined | bigint | Int8<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | bigint | Int8<number>
    • a2: undefined | bigint | Int8<number>

    Returns Text<0 | 1>

  • pgReadFile(
        this: Text<1>,
        a1: undefined | bigint | Int8<1>,
        a2: undefined | bigint | Int8<1>,
        a3: undefined | boolean | Bool<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | bigint | Int8<1>
    • a2: undefined | bigint | Int8<1>
    • a3: undefined | boolean | Bool<1>

    Returns Text<1>

  • pgReadFile(
        this: Text<0 | 1>,
        a1: undefined | bigint | Int8<0 | 1>,
        a2: undefined | bigint | Int8<0 | 1>,
        a3: undefined | boolean | Bool<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | bigint | Int8<0 | 1>
    • a2: undefined | bigint | Int8<0 | 1>
    • a3: undefined | boolean | Bool<0 | 1>

    Returns Text<0 | 1>

  • pgReadFile(
        this: Text<number>,
        a1: undefined | bigint | Int8<number>,
        a2: undefined | bigint | Int8<number>,
        a3: undefined | boolean | Bool<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | bigint | Int8<number>
    • a2: undefined | bigint | Int8<number>
    • a3: undefined | boolean | Bool<number>

    Returns Text<0 | 1>

pgReplicationOriginAdvance

  • pgReplicationOriginAdvance(this: Text<1>, a1: PgLsn<1>): Void<1>

    Parameters

    Returns Void<1>

  • pgReplicationOriginAdvance(this: Text<0 | 1>, a1: PgLsn<0 | 1>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

  • pgReplicationOriginAdvance(this: Text<number>, a1: PgLsn<number>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

pgReplicationOriginCreate

  • pgReplicationOriginCreate(this: Text<1>): Oid<1>

    Parameters

    Returns Oid<1>

  • pgReplicationOriginCreate(this: Text<0 | 1>): Oid<0 | 1>

    Parameters

    Returns Oid<0 | 1>

  • pgReplicationOriginCreate(this: Text<number>): Oid<0 | 1>

    Parameters

    Returns Oid<0 | 1>

pgReplicationOriginDrop

  • pgReplicationOriginDrop(this: Text<1>): Void<1>

    Parameters

    Returns Void<1>

  • pgReplicationOriginDrop(this: Text<0 | 1>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

  • pgReplicationOriginDrop(this: Text<number>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

pgReplicationOriginOid

  • pgReplicationOriginOid(this: Text<1>): Oid<1>

    Parameters

    Returns Oid<1>

  • pgReplicationOriginOid(this: Text<0 | 1>): Oid<0 | 1>

    Parameters

    Returns Oid<0 | 1>

  • pgReplicationOriginOid(this: Text<number>): Oid<0 | 1>

    Parameters

    Returns Oid<0 | 1>

pgReplicationOriginProgress

  • pgReplicationOriginProgress(
        this: Text<1>,
        a1: undefined | boolean | Bool<1>,
    ): PgLsn<1>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>

    Returns PgLsn<1>

  • pgReplicationOriginProgress(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
    ): PgLsn<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>

    Returns PgLsn<0 | 1>

  • pgReplicationOriginProgress(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
    ): PgLsn<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>

    Returns PgLsn<0 | 1>

pgReplicationOriginSessionSetup

  • pgReplicationOriginSessionSetup(this: Text<1>): Void<1>

    Parameters

    Returns Void<1>

  • pgReplicationOriginSessionSetup(this: Text<0 | 1>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

  • pgReplicationOriginSessionSetup(this: Text<number>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

pgSettingsGetFlags

  • pgSettingsGetFlags(this: Text<1>): Array<1, Text<0 | 1>>

    Parameters

    Returns Array<1, Text<0 | 1>>

  • pgSettingsGetFlags(this: Text<0 | 1>): Array<0 | 1, Text<0 | 1>>

    Parameters

    Returns Array<0 | 1, Text<0 | 1>>

  • pgSettingsGetFlags(this: Text<number>): Array<0 | 1, Text<0 | 1>>

    Parameters

    Returns Array<0 | 1, Text<0 | 1>>

pgSizeBytes

  • pgSizeBytes(this: Text<1>): Int8<1>

    Parameters

    Returns Int8<1>

  • pgSizeBytes(this: Text<0 | 1>): Int8<0 | 1>

    Parameters

    Returns Int8<0 | 1>

  • pgSizeBytes(this: Text<number>): Int8<0 | 1>

    Parameters

    Returns Int8<0 | 1>

pgSplitWalfileName

  • pgSplitWalfileName(
        this: Text<1>,
    ): Record<1, { segment_number: Numeric<1>; timeline_id: Int8<1> }>

    Parameters

    Returns Record<1, { segment_number: Numeric<1>; timeline_id: Int8<1> }>

  • pgSplitWalfileName(
        this: Text<0 | 1>,
    ): Record<
        0
        | 1,
        { segment_number: Numeric<0 | 1>; timeline_id: Int8<0 | 1> },
    >

    Parameters

    Returns Record<0 | 1, { segment_number: Numeric<0 | 1>; timeline_id: Int8<0 | 1> }>

  • pgSplitWalfileName(
        this: Text<number>,
    ): Record<
        0
        | 1,
        { segment_number: Numeric<0 | 1>; timeline_id: Int8<0 | 1> },
    >

    Parameters

    Returns Record<0 | 1, { segment_number: Numeric<0 | 1>; timeline_id: Int8<0 | 1> }>

pgStatFile

  • pgStatFile(
        this: Text<1>,
    ): Record<
        1,
        {
            access: Timestamptz<1>;
            change: Timestamptz<1>;
            creation: Timestamptz<1>;
            isdir: Bool<1>;
            modification: Timestamptz<1>;
            size: Int8<1>;
        },
    >

    Parameters

    Returns Record<
        1,
        {
            access: Timestamptz<1>;
            change: Timestamptz<1>;
            creation: Timestamptz<1>;
            isdir: Bool<1>;
            modification: Timestamptz<1>;
            size: Int8<1>;
        },
    >

  • pgStatFile(
        this: Text<0 | 1>,
    ): Record<
        0
        | 1,
        {
            access: Timestamptz<0 | 1>;
            change: Timestamptz<0 | 1>;
            creation: Timestamptz<0 | 1>;
            isdir: Bool<0 | 1>;
            modification: Timestamptz<0 | 1>;
            size: Int8<0 | 1>;
        },
    >

    Parameters

    Returns Record<
        0
        | 1,
        {
            access: Timestamptz<0 | 1>;
            change: Timestamptz<0 | 1>;
            creation: Timestamptz<0 | 1>;
            isdir: Bool<0 | 1>;
            modification: Timestamptz<0 | 1>;
            size: Int8<0 | 1>;
        },
    >

  • pgStatFile(
        this: Text<number>,
    ): Record<
        0
        | 1,
        {
            access: Timestamptz<0 | 1>;
            change: Timestamptz<0 | 1>;
            creation: Timestamptz<0 | 1>;
            isdir: Bool<0 | 1>;
            modification: Timestamptz<0 | 1>;
            size: Int8<0 | 1>;
        },
    >

    Parameters

    Returns Record<
        0
        | 1,
        {
            access: Timestamptz<0 | 1>;
            change: Timestamptz<0 | 1>;
            creation: Timestamptz<0 | 1>;
            isdir: Bool<0 | 1>;
            modification: Timestamptz<0 | 1>;
            size: Int8<0 | 1>;
        },
    >

  • pgStatFile(
        this: Text<1>,
        a1: undefined | boolean | Bool<1>,
    ): Record<
        1,
        {
            access: Timestamptz<1>;
            change: Timestamptz<1>;
            creation: Timestamptz<1>;
            isdir: Bool<1>;
            modification: Timestamptz<1>;
            size: Int8<1>;
        },
    >

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>

    Returns Record<
        1,
        {
            access: Timestamptz<1>;
            change: Timestamptz<1>;
            creation: Timestamptz<1>;
            isdir: Bool<1>;
            modification: Timestamptz<1>;
            size: Int8<1>;
        },
    >

  • pgStatFile(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
    ): Record<
        0
        | 1,
        {
            access: Timestamptz<0 | 1>;
            change: Timestamptz<0 | 1>;
            creation: Timestamptz<0 | 1>;
            isdir: Bool<0 | 1>;
            modification: Timestamptz<0 | 1>;
            size: Int8<0 | 1>;
        },
    >

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>

    Returns Record<
        0
        | 1,
        {
            access: Timestamptz<0 | 1>;
            change: Timestamptz<0 | 1>;
            creation: Timestamptz<0 | 1>;
            isdir: Bool<0 | 1>;
            modification: Timestamptz<0 | 1>;
            size: Int8<0 | 1>;
        },
    >

  • pgStatFile(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
    ): Record<
        0
        | 1,
        {
            access: Timestamptz<0 | 1>;
            change: Timestamptz<0 | 1>;
            creation: Timestamptz<0 | 1>;
            isdir: Bool<0 | 1>;
            modification: Timestamptz<0 | 1>;
            size: Int8<0 | 1>;
        },
    >

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>

    Returns Record<
        0
        | 1,
        {
            access: Timestamptz<0 | 1>;
            change: Timestamptz<0 | 1>;
            creation: Timestamptz<0 | 1>;
            isdir: Bool<0 | 1>;
            modification: Timestamptz<0 | 1>;
            size: Int8<0 | 1>;
        },
    >

pgStatGetProgressInfo

  • pgStatGetProgressInfo(
        this: Text<1>,
    ): Setof<
        {
            from: {
                datid: Oid<1>;
                param1: Int8<1>;
                param10: Int8<1>;
                param11: Int8<1>;
                param12: Int8<1>;
                param13: Int8<1>;
                param14: Int8<1>;
                param15: Int8<1>;
                param16: Int8<1>;
                param17: Int8<1>;
                param18: Int8<1>;
                param19: Int8<1>;
                param2: Int8<1>;
                param20: Int8<1>;
                param3: Int8<1>;
                param4: Int8<1>;
                param5: Int8<1>;
                param6: Int8<1>;
                param7: Int8<1>;
                param8: Int8<1>;
                param9: Int8<1>;
                pid: Int4<1>;
                relid: Oid<1>;
            };
        },
    >

    Parameters

    Returns Setof<
        {
            from: {
                datid: Oid<1>;
                param1: Int8<1>;
                param10: Int8<1>;
                param11: Int8<1>;
                param12: Int8<1>;
                param13: Int8<1>;
                param14: Int8<1>;
                param15: Int8<1>;
                param16: Int8<1>;
                param17: Int8<1>;
                param18: Int8<1>;
                param19: Int8<1>;
                param2: Int8<1>;
                param20: Int8<1>;
                param3: Int8<1>;
                param4: Int8<1>;
                param5: Int8<1>;
                param6: Int8<1>;
                param7: Int8<1>;
                param8: Int8<1>;
                param9: Int8<1>;
                pid: Int4<1>;
                relid: Oid<1>;
            };
        },
    >

  • pgStatGetProgressInfo(
        this: Text<0 | 1>,
    ): Setof<
        {
            from: {
                datid: Oid<0 | 1>;
                param1: Int8<0 | 1>;
                param10: Int8<0 | 1>;
                param11: Int8<0 | 1>;
                param12: Int8<0 | 1>;
                param13: Int8<0 | 1>;
                param14: Int8<0 | 1>;
                param15: Int8<0 | 1>;
                param16: Int8<0 | 1>;
                param17: Int8<0 | 1>;
                param18: Int8<0 | 1>;
                param19: Int8<0 | 1>;
                param2: Int8<0 | 1>;
                param20: Int8<0 | 1>;
                param3: Int8<0 | 1>;
                param4: Int8<0 | 1>;
                param5: Int8<0 | 1>;
                param6: Int8<0 | 1>;
                param7: Int8<0 | 1>;
                param8: Int8<0 | 1>;
                param9: Int8<0 | 1>;
                pid: Int4<0 | 1>;
                relid: Oid<0 | 1>;
            };
        },
    >

    Parameters

    Returns Setof<
        {
            from: {
                datid: Oid<0 | 1>;
                param1: Int8<0 | 1>;
                param10: Int8<0 | 1>;
                param11: Int8<0 | 1>;
                param12: Int8<0 | 1>;
                param13: Int8<0 | 1>;
                param14: Int8<0 | 1>;
                param15: Int8<0 | 1>;
                param16: Int8<0 | 1>;
                param17: Int8<0 | 1>;
                param18: Int8<0 | 1>;
                param19: Int8<0 | 1>;
                param2: Int8<0 | 1>;
                param20: Int8<0 | 1>;
                param3: Int8<0 | 1>;
                param4: Int8<0 | 1>;
                param5: Int8<0 | 1>;
                param6: Int8<0 | 1>;
                param7: Int8<0 | 1>;
                param8: Int8<0 | 1>;
                param9: Int8<0 | 1>;
                pid: Int4<0 | 1>;
                relid: Oid<0 | 1>;
            };
        },
    >

  • pgStatGetProgressInfo(
        this: Text<number>,
    ): Setof<
        {
            from: {
                datid: Oid<0 | 1>;
                param1: Int8<0 | 1>;
                param10: Int8<0 | 1>;
                param11: Int8<0 | 1>;
                param12: Int8<0 | 1>;
                param13: Int8<0 | 1>;
                param14: Int8<0 | 1>;
                param15: Int8<0 | 1>;
                param16: Int8<0 | 1>;
                param17: Int8<0 | 1>;
                param18: Int8<0 | 1>;
                param19: Int8<0 | 1>;
                param2: Int8<0 | 1>;
                param20: Int8<0 | 1>;
                param3: Int8<0 | 1>;
                param4: Int8<0 | 1>;
                param5: Int8<0 | 1>;
                param6: Int8<0 | 1>;
                param7: Int8<0 | 1>;
                param8: Int8<0 | 1>;
                param9: Int8<0 | 1>;
                pid: Int4<0 | 1>;
                relid: Oid<0 | 1>;
            };
        },
    >

    Parameters

    Returns Setof<
        {
            from: {
                datid: Oid<0 | 1>;
                param1: Int8<0 | 1>;
                param10: Int8<0 | 1>;
                param11: Int8<0 | 1>;
                param12: Int8<0 | 1>;
                param13: Int8<0 | 1>;
                param14: Int8<0 | 1>;
                param15: Int8<0 | 1>;
                param16: Int8<0 | 1>;
                param17: Int8<0 | 1>;
                param18: Int8<0 | 1>;
                param19: Int8<0 | 1>;
                param2: Int8<0 | 1>;
                param20: Int8<0 | 1>;
                param3: Int8<0 | 1>;
                param4: Int8<0 | 1>;
                param5: Int8<0 | 1>;
                param6: Int8<0 | 1>;
                param7: Int8<0 | 1>;
                param8: Int8<0 | 1>;
                param9: Int8<0 | 1>;
                pid: Int4<0 | 1>;
                relid: Oid<0 | 1>;
            };
        },
    >

pgStatGetReplicationSlot

  • pgStatGetReplicationSlot(
        this: Text<1>,
    ): Record<
        1,
        {
            slot_name: Text<1>;
            spill_bytes: Int8<1>;
            spill_count: Int8<1>;
            spill_txns: Int8<1>;
            stats_reset: Timestamptz<1>;
            stream_bytes: Int8<1>;
            stream_count: Int8<1>;
            stream_txns: Int8<1>;
            total_bytes: Int8<1>;
            total_txns: Int8<1>;
        },
    >

    Parameters

    Returns Record<
        1,
        {
            slot_name: Text<1>;
            spill_bytes: Int8<1>;
            spill_count: Int8<1>;
            spill_txns: Int8<1>;
            stats_reset: Timestamptz<1>;
            stream_bytes: Int8<1>;
            stream_count: Int8<1>;
            stream_txns: Int8<1>;
            total_bytes: Int8<1>;
            total_txns: Int8<1>;
        },
    >

  • pgStatGetReplicationSlot(
        this: Text<0 | 1>,
    ): Record<
        0
        | 1,
        {
            slot_name: Text<0 | 1>;
            spill_bytes: Int8<0 | 1>;
            spill_count: Int8<0 | 1>;
            spill_txns: Int8<0 | 1>;
            stats_reset: Timestamptz<0 | 1>;
            stream_bytes: Int8<0 | 1>;
            stream_count: Int8<0 | 1>;
            stream_txns: Int8<0 | 1>;
            total_bytes: Int8<0 | 1>;
            total_txns: Int8<0 | 1>;
        },
    >

    Parameters

    Returns Record<
        0
        | 1,
        {
            slot_name: Text<0 | 1>;
            spill_bytes: Int8<0 | 1>;
            spill_count: Int8<0 | 1>;
            spill_txns: Int8<0 | 1>;
            stats_reset: Timestamptz<0 | 1>;
            stream_bytes: Int8<0 | 1>;
            stream_count: Int8<0 | 1>;
            stream_txns: Int8<0 | 1>;
            total_bytes: Int8<0 | 1>;
            total_txns: Int8<0 | 1>;
        },
    >

  • pgStatGetReplicationSlot(
        this: Text<number>,
    ): Record<
        0
        | 1,
        {
            slot_name: Text<0 | 1>;
            spill_bytes: Int8<0 | 1>;
            spill_count: Int8<0 | 1>;
            spill_txns: Int8<0 | 1>;
            stats_reset: Timestamptz<0 | 1>;
            stream_bytes: Int8<0 | 1>;
            stream_count: Int8<0 | 1>;
            stream_txns: Int8<0 | 1>;
            total_bytes: Int8<0 | 1>;
            total_txns: Int8<0 | 1>;
        },
    >

    Parameters

    Returns Record<
        0
        | 1,
        {
            slot_name: Text<0 | 1>;
            spill_bytes: Int8<0 | 1>;
            spill_count: Int8<0 | 1>;
            spill_txns: Int8<0 | 1>;
            stats_reset: Timestamptz<0 | 1>;
            stream_bytes: Int8<0 | 1>;
            stream_count: Int8<0 | 1>;
            stream_txns: Int8<0 | 1>;
            total_bytes: Int8<0 | 1>;
            total_txns: Int8<0 | 1>;
        },
    >

pgStatHaveStats

  • pgStatHaveStats(this: Text<1>, a1: Oid<1>, a2: Oid<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • pgStatHaveStats(this: Text<0 | 1>, a1: Oid<0 | 1>, a2: Oid<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • pgStatHaveStats(
        this: Text<number>,
        a1: Oid<number>,
        a2: Oid<number>,
    ): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

pgStatResetReplicationSlot

  • pgStatResetReplicationSlot(this: Text<1>): Void<1>

    Parameters

    Returns Void<1>

  • pgStatResetReplicationSlot(this: Text<0 | 1>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

  • pgStatResetReplicationSlot(this: Text<number>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

pgStatResetShared

  • pgStatResetShared(this: Text<1>): Void<1>

    Parameters

    Returns Void<1>

  • pgStatResetShared(this: Text<0 | 1>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

  • pgStatResetShared(this: Text<number>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

pgStatResetSlru

  • pgStatResetSlru(this: Text<1>): Void<1>

    Parameters

    Returns Void<1>

  • pgStatResetSlru(this: Text<0 | 1>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

  • pgStatResetSlru(this: Text<number>): Void<0 | 1>

    Parameters

    Returns Void<0 | 1>

pgTypeof

  • pgTypeof<T extends Any<unknown, number>>(this: T): Regtype<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Regtype<1>

  • pgTypeof<T extends Any<unknown, number>>(this: T): Regtype<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Regtype<0 | 1>

  • pgTypeof<T extends Any<unknown, number>>(this: T): Regtype<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Regtype<0 | 1>

phrasetoTsquery

  • phrasetoTsquery(this: Text<1>): Tsquery<1>

    Parameters

    Returns Tsquery<1>

  • phrasetoTsquery(this: Text<0 | 1>): Tsquery<0 | 1>

    Parameters

    Returns Tsquery<0 | 1>

  • phrasetoTsquery(this: Text<number>): Tsquery<0 | 1>

    Parameters

    Returns Tsquery<0 | 1>

plaintoTsquery

  • plaintoTsquery(this: Text<1>): Tsquery<1>

    Parameters

    Returns Tsquery<1>

  • plaintoTsquery(this: Text<0 | 1>): Tsquery<0 | 1>

    Parameters

    Returns Tsquery<0 | 1>

  • plaintoTsquery(this: Text<number>): Tsquery<0 | 1>

    Parameters

    Returns Tsquery<0 | 1>

position

  • position(this: Text<1>, a1: undefined | string | Text<1>): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Int4<1>

  • position(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Int4<0 | 1>

  • position(this: Text<number>, a1: undefined | string | Text<number>): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Int4<0 | 1>

queryToXml

  • queryToXml(
        this: Text<1>,
        a1: undefined | boolean | Bool<1>,
        a2: undefined | boolean | Bool<1>,
        a3: undefined | string | Text<1>,
    ): Xml<1>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>
    • a2: undefined | boolean | Bool<1>
    • a3: undefined | string | Text<1>

    Returns Xml<1>

  • queryToXml(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
        a2: undefined | boolean | Bool<0 | 1>,
        a3: undefined | string | Text<0 | 1>,
    ): Xml<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>
    • a2: undefined | boolean | Bool<0 | 1>
    • a3: undefined | string | Text<0 | 1>

    Returns Xml<0 | 1>

  • queryToXml(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
        a2: undefined | boolean | Bool<number>,
        a3: undefined | string | Text<number>,
    ): Xml<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>
    • a2: undefined | boolean | Bool<number>
    • a3: undefined | string | Text<number>

    Returns Xml<0 | 1>

queryToXmlAndXmlschema

  • queryToXmlAndXmlschema(
        this: Text<1>,
        a1: undefined | boolean | Bool<1>,
        a2: undefined | boolean | Bool<1>,
        a3: undefined | string | Text<1>,
    ): Xml<1>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>
    • a2: undefined | boolean | Bool<1>
    • a3: undefined | string | Text<1>

    Returns Xml<1>

  • queryToXmlAndXmlschema(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
        a2: undefined | boolean | Bool<0 | 1>,
        a3: undefined | string | Text<0 | 1>,
    ): Xml<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>
    • a2: undefined | boolean | Bool<0 | 1>
    • a3: undefined | string | Text<0 | 1>

    Returns Xml<0 | 1>

  • queryToXmlAndXmlschema(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
        a2: undefined | boolean | Bool<number>,
        a3: undefined | string | Text<number>,
    ): Xml<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>
    • a2: undefined | boolean | Bool<number>
    • a3: undefined | string | Text<number>

    Returns Xml<0 | 1>

queryToXmlschema

  • queryToXmlschema(
        this: Text<1>,
        a1: undefined | boolean | Bool<1>,
        a2: undefined | boolean | Bool<1>,
        a3: undefined | string | Text<1>,
    ): Xml<1>

    Parameters

    • this: Text<1>
    • a1: undefined | boolean | Bool<1>
    • a2: undefined | boolean | Bool<1>
    • a3: undefined | string | Text<1>

    Returns Xml<1>

  • queryToXmlschema(
        this: Text<0 | 1>,
        a1: undefined | boolean | Bool<0 | 1>,
        a2: undefined | boolean | Bool<0 | 1>,
        a3: undefined | string | Text<0 | 1>,
    ): Xml<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | boolean | Bool<0 | 1>
    • a2: undefined | boolean | Bool<0 | 1>
    • a3: undefined | string | Text<0 | 1>

    Returns Xml<0 | 1>

  • queryToXmlschema(
        this: Text<number>,
        a1: undefined | boolean | Bool<number>,
        a2: undefined | boolean | Bool<number>,
        a3: undefined | string | Text<number>,
    ): Xml<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | boolean | Bool<number>
    • a2: undefined | boolean | Bool<number>
    • a3: undefined | string | Text<number>

    Returns Xml<0 | 1>

quoteIdent

  • quoteIdent(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • quoteIdent(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • quoteIdent(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

quoteLiteral

quoteNullable

rank

  • rank<T extends Any<unknown, number>>(this: T): Int8<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int8<0 | 1>

regclass

  • regclass(this: Text<1>): Regclass<1>

    Parameters

    Returns Regclass<1>

  • regclass(this: Text<0 | 1>): Regclass<0 | 1>

    Parameters

    Returns Regclass<0 | 1>

  • regclass(this: Text<number>): Regclass<0 | 1>

    Parameters

    Returns Regclass<0 | 1>

regexpCount

  • regexpCount(this: Text<1>, a1: undefined | string | Text<1>): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Int4<1>

  • regexpCount(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Int4<0 | 1>

  • regexpCount(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Int4<0 | 1>

  • regexpCount(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
    ): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>

    Returns Int4<1>

  • regexpCount(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>

    Returns Int4<0 | 1>

  • regexpCount(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>

    Returns Int4<0 | 1>

  • regexpCount(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
        a3: undefined | string | Text<1>,
    ): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>
    • a3: undefined | string | Text<1>

    Returns Int4<1>

  • regexpCount(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
        a3: undefined | string | Text<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>
    • a3: undefined | string | Text<0 | 1>

    Returns Int4<0 | 1>

  • regexpCount(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
        a3: undefined | string | Text<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>
    • a3: undefined | string | Text<number>

    Returns Int4<0 | 1>

regexpInstr

  • regexpInstr(this: Text<1>, a1: undefined | string | Text<1>): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Int4<1>

  • regexpInstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
    ): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>

    Returns Int4<1>

  • regexpInstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
        a3: undefined | number | Int4<1>,
    ): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>
    • a3: undefined | number | Int4<1>

    Returns Int4<1>

  • regexpInstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>
    • a3: undefined | number | Int4<0 | 1>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
        a3: undefined | number | Int4<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>
    • a3: undefined | number | Int4<number>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
        a3: undefined | number | Int4<1>,
        a4: undefined | number | Int4<1>,
    ): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>
    • a3: undefined | number | Int4<1>
    • a4: undefined | number | Int4<1>

    Returns Int4<1>

  • regexpInstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
        a4: undefined | number | Int4<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>
    • a3: undefined | number | Int4<0 | 1>
    • a4: undefined | number | Int4<0 | 1>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
        a3: undefined | number | Int4<number>,
        a4: undefined | number | Int4<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>
    • a3: undefined | number | Int4<number>
    • a4: undefined | number | Int4<number>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
        a3: undefined | number | Int4<1>,
        a4: undefined | number | Int4<1>,
        a5: undefined | string | Text<1>,
    ): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>
    • a3: undefined | number | Int4<1>
    • a4: undefined | number | Int4<1>
    • a5: undefined | string | Text<1>

    Returns Int4<1>

  • regexpInstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
        a4: undefined | number | Int4<0 | 1>,
        a5: undefined | string | Text<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>
    • a3: undefined | number | Int4<0 | 1>
    • a4: undefined | number | Int4<0 | 1>
    • a5: undefined | string | Text<0 | 1>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
        a3: undefined | number | Int4<number>,
        a4: undefined | number | Int4<number>,
        a5: undefined | string | Text<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>
    • a3: undefined | number | Int4<number>
    • a4: undefined | number | Int4<number>
    • a5: undefined | string | Text<number>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
        a3: undefined | number | Int4<1>,
        a4: undefined | number | Int4<1>,
        a5: undefined | string | Text<1>,
        a6: undefined | number | Int4<1>,
    ): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>
    • a3: undefined | number | Int4<1>
    • a4: undefined | number | Int4<1>
    • a5: undefined | string | Text<1>
    • a6: undefined | number | Int4<1>

    Returns Int4<1>

  • regexpInstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
        a4: undefined | number | Int4<0 | 1>,
        a5: undefined | string | Text<0 | 1>,
        a6: undefined | number | Int4<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>
    • a3: undefined | number | Int4<0 | 1>
    • a4: undefined | number | Int4<0 | 1>
    • a5: undefined | string | Text<0 | 1>
    • a6: undefined | number | Int4<0 | 1>

    Returns Int4<0 | 1>

  • regexpInstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
        a3: undefined | number | Int4<number>,
        a4: undefined | number | Int4<number>,
        a5: undefined | string | Text<number>,
        a6: undefined | number | Int4<number>,
    ): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>
    • a3: undefined | number | Int4<number>
    • a4: undefined | number | Int4<number>
    • a5: undefined | string | Text<number>
    • a6: undefined | number | Int4<number>

    Returns Int4<0 | 1>

regexpLike

  • regexpLike(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • regexpLike(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • regexpLike(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

  • regexpLike(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Bool<1>

  • regexpLike(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • regexpLike(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Bool<0 | 1>

regexpMatch

  • regexpMatch(
        this: Text<1>,
        a1: undefined | string | Text<1>,
    ): Array<1, Text<0 | 1>>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Array<1, Text<0 | 1>>

  • regexpMatch(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Array<0 | 1, Text<0 | 1>>

  • regexpMatch(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Array<0 | 1, Text<0 | 1>>

  • regexpMatch(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Array<1, Text<0 | 1>>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Array<1, Text<0 | 1>>

  • regexpMatch(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Array<0 | 1, Text<0 | 1>>

  • regexpMatch(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Array<0 | 1, Text<0 | 1>>

regexpMatches

  • regexpMatches(
        this: Text<1>,
        a1: undefined | string | Text<1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Setof<{ from: {} }>

  • regexpMatches(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Setof<{ from: {} }>

  • regexpMatches(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Setof<{ from: {} }>

  • regexpMatches(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Setof<{ from: {} }>

  • regexpMatches(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Setof<{ from: {} }>

  • regexpMatches(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Setof<{ from: {} }>

regexpReplace

  • regexpReplace(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Text<1>

  • regexpReplace(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • regexpReplace(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Text<0 | 1>

  • regexpReplace(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
        a3: undefined | number | Int4<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>
    • a3: undefined | number | Int4<1>

    Returns Text<1>

  • regexpReplace(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>
    • a3: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • regexpReplace(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
        a3: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>
    • a3: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • regexpReplace(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
        a3: undefined | number | Int4<1>,
        a4: undefined | number | Int4<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>
    • a3: undefined | number | Int4<1>
    • a4: undefined | number | Int4<1>

    Returns Text<1>

  • regexpReplace(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
        a4: undefined | number | Int4<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>
    • a3: undefined | number | Int4<0 | 1>
    • a4: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • regexpReplace(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
        a3: undefined | number | Int4<number>,
        a4: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>
    • a3: undefined | number | Int4<number>
    • a4: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • regexpReplace(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
        a3: undefined | number | Int4<1>,
        a4: undefined | number | Int4<1>,
        a5: undefined | string | Text<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>
    • a3: undefined | number | Int4<1>
    • a4: undefined | number | Int4<1>
    • a5: undefined | string | Text<1>

    Returns Text<1>

  • regexpReplace(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
        a4: undefined | number | Int4<0 | 1>,
        a5: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>
    • a3: undefined | number | Int4<0 | 1>
    • a4: undefined | number | Int4<0 | 1>
    • a5: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • regexpReplace(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
        a3: undefined | number | Int4<number>,
        a4: undefined | number | Int4<number>,
        a5: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>
    • a3: undefined | number | Int4<number>
    • a4: undefined | number | Int4<number>
    • a5: undefined | string | Text<number>

    Returns Text<0 | 1>

  • regexpReplace(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
        a3: undefined | string | Text<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>
    • a3: undefined | string | Text<1>

    Returns Text<1>

  • regexpReplace(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
        a3: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>
    • a3: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • regexpReplace(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
        a3: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>
    • a3: undefined | string | Text<number>

    Returns Text<0 | 1>

regexpSplitToArray

  • regexpSplitToArray(
        this: Text<1>,
        a1: undefined | string | Text<1>,
    ): Array<1, Text<0 | 1>>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Array<1, Text<0 | 1>>

  • regexpSplitToArray(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Array<0 | 1, Text<0 | 1>>

  • regexpSplitToArray(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Array<0 | 1, Text<0 | 1>>

  • regexpSplitToArray(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Array<1, Text<0 | 1>>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Array<1, Text<0 | 1>>

  • regexpSplitToArray(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Array<0 | 1, Text<0 | 1>>

  • regexpSplitToArray(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Array<0 | 1, Text<0 | 1>>

regexpSplitToTable

  • regexpSplitToTable(
        this: Text<1>,
        a1: undefined | string | Text<1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Setof<{ from: {} }>

  • regexpSplitToTable(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Setof<{ from: {} }>

  • regexpSplitToTable(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Setof<{ from: {} }>

  • regexpSplitToTable(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Setof<{ from: {} }>

  • regexpSplitToTable(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Setof<{ from: {} }>

  • regexpSplitToTable(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Setof<{ from: {} }>

regexpSubstr

  • regexpSubstr(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • regexpSubstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • regexpSubstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

  • regexpSubstr(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>

    Returns Text<1>

  • regexpSubstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • regexpSubstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • regexpSubstr(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
        a3: undefined | number | Int4<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>
    • a3: undefined | number | Int4<1>

    Returns Text<1>

  • regexpSubstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>
    • a3: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • regexpSubstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
        a3: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>
    • a3: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • regexpSubstr(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
        a3: undefined | number | Int4<1>,
        a4: undefined | string | Text<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>
    • a3: undefined | number | Int4<1>
    • a4: undefined | string | Text<1>

    Returns Text<1>

  • regexpSubstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
        a4: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>
    • a3: undefined | number | Int4<0 | 1>
    • a4: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • regexpSubstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
        a3: undefined | number | Int4<number>,
        a4: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>
    • a3: undefined | number | Int4<number>
    • a4: undefined | string | Text<number>

    Returns Text<0 | 1>

  • regexpSubstr(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
        a3: undefined | number | Int4<1>,
        a4: undefined | string | Text<1>,
        a5: undefined | number | Int4<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>
    • a3: undefined | number | Int4<1>
    • a4: undefined | string | Text<1>
    • a5: undefined | number | Int4<1>

    Returns Text<1>

  • regexpSubstr(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
        a3: undefined | number | Int4<0 | 1>,
        a4: undefined | string | Text<0 | 1>,
        a5: undefined | number | Int4<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>
    • a3: undefined | number | Int4<0 | 1>
    • a4: undefined | string | Text<0 | 1>
    • a5: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • regexpSubstr(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
        a3: undefined | number | Int4<number>,
        a4: undefined | string | Text<number>,
        a5: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>
    • a3: undefined | number | Int4<number>
    • a4: undefined | string | Text<number>
    • a5: undefined | number | Int4<number>

    Returns Text<0 | 1>

repeat

  • repeat(this: Text<1>, a1: undefined | number | Int4<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>

    Returns Text<1>

  • repeat(this: Text<0 | 1>, a1: undefined | number | Int4<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • repeat(this: Text<number>, a1: undefined | number | Int4<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>

    Returns Text<0 | 1>

replace

  • replace(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Text<1>

  • replace(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • replace(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Text<0 | 1>

reverse

  • reverse(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • reverse(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • reverse(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

right

  • right(this: Text<1>, a1: undefined | number | Int4<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>

    Returns Text<1>

  • right(this: Text<0 | 1>, a1: undefined | number | Int4<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • right(this: Text<number>, a1: undefined | number | Int4<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>

    Returns Text<0 | 1>

rowSecurityActive

  • rowSecurityActive(this: Text<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • rowSecurityActive(this: Text<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • rowSecurityActive(this: Text<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

rpad

  • rpad(this: Text<1>, a1: undefined | number | Int4<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>

    Returns Text<1>

  • rpad(this: Text<0 | 1>, a1: undefined | number | Int4<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • rpad(this: Text<number>, a1: undefined | number | Int4<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • rpad(
        this: Text<1>,
        a1: undefined | number | Int4<1>,
        a2: undefined | string | Text<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>
    • a2: undefined | string | Text<1>

    Returns Text<1>

  • rpad(
        this: Text<0 | 1>,
        a1: undefined | number | Int4<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • rpad(
        this: Text<number>,
        a1: undefined | number | Int4<number>,
        a2: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>
    • a2: undefined | string | Text<number>

    Returns Text<0 | 1>

rtrim

  • rtrim(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • rtrim(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • rtrim(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • rtrim(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • rtrim(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • rtrim(this: Text<number>, a1: undefined | string | Text<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

setConfig

  • setConfig(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | boolean | Bool<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | boolean | Bool<1>

    Returns Text<1>

  • setConfig(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | boolean | Bool<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | boolean | Bool<0 | 1>

    Returns Text<0 | 1>

  • setConfig(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | boolean | Bool<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | boolean | Bool<number>

    Returns Text<0 | 1>

similarEscape

  • similarEscape(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • similarEscape(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • similarEscape(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

similarToEscape

  • similarToEscape(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • similarToEscape(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • similarToEscape(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • similarToEscape(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • similarToEscape(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • similarToEscape(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

splitPart

  • splitPart(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | number | Int4<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | number | Int4<1>

    Returns Text<1>

  • splitPart(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • splitPart(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | number | Int4<number>

    Returns Text<0 | 1>

startsWith

  • startsWith(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • startsWith(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • startsWith(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

stringAgg

  • stringAgg(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

stringToArray

  • stringToArray(
        this: Text<1>,
        a1: undefined | string | Text<1>,
    ): Array<1, Text<0 | 1>>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Array<1, Text<0 | 1>>

  • stringToArray(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Array<0 | 1, Text<0 | 1>>

  • stringToArray(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Array<0 | 1, Text<0 | 1>>

  • stringToArray(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Array<1, Text<0 | 1>>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Array<1, Text<0 | 1>>

  • stringToArray(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Array<0 | 1, Text<0 | 1>>

  • stringToArray(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Array<0 | 1, Text<0 | 1>>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Array<0 | 1, Text<0 | 1>>

stringToTable

  • stringToTable(
        this: Text<1>,
        a1: undefined | string | Text<1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Setof<{ from: {} }>

  • stringToTable(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Setof<{ from: {} }>

  • stringToTable(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Setof<{ from: {} }>

  • stringToTable(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Setof<{ from: {} }>

  • stringToTable(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Setof<{ from: {} }>

  • stringToTable(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Setof<{ from: {} }>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Setof<{ from: {} }>

strpos

  • strpos(this: Text<1>, a1: undefined | string | Text<1>): Int4<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Int4<1>

  • strpos(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Int4<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Int4<0 | 1>

  • strpos(this: Text<number>, a1: undefined | string | Text<number>): Int4<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Int4<0 | 1>

substr

  • substr(this: Text<1>, a1: undefined | number | Int4<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>

    Returns Text<1>

  • substr(this: Text<0 | 1>, a1: undefined | number | Int4<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • substr(this: Text<number>, a1: undefined | number | Int4<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • substr(
        this: Text<1>,
        a1: undefined | number | Int4<1>,
        a2: undefined | number | Int4<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>
    • a2: undefined | number | Int4<1>

    Returns Text<1>

  • substr(
        this: Text<0 | 1>,
        a1: undefined | number | Int4<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>
    • a2: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • substr(
        this: Text<number>,
        a1: undefined | number | Int4<number>,
        a2: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>
    • a2: undefined | number | Int4<number>

    Returns Text<0 | 1>

substring

  • substring(this: Text<1>, a1: undefined | number | Int4<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>

    Returns Text<1>

  • substring(this: Text<0 | 1>, a1: undefined | number | Int4<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • substring(
        this: Text<number>,
        a1: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • substring(
        this: Text<1>,
        a1: undefined | number | Int4<1>,
        a2: undefined | number | Int4<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>
    • a2: undefined | number | Int4<1>

    Returns Text<1>

  • substring(
        this: Text<0 | 1>,
        a1: undefined | number | Int4<0 | 1>,
        a2: undefined | number | Int4<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>
    • a2: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • substring(
        this: Text<number>,
        a1: undefined | number | Int4<number>,
        a2: undefined | number | Int4<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>
    • a2: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • substring(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • substring(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • substring(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

  • substring(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Text<1>

  • substring(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • substring(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Text<0 | 1>

textanycat

  • textanycat<T extends Any<unknown, number>>(
        this: Text<1>,
        a1: T | Input<T>,
    ): Text<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Text<1>

  • textanycat<T extends Any<unknown, number>>(
        this: Text<0 | 1>,
        a1: T | Input<T>,
    ): Text<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Text<0 | 1>

  • textanycat<T extends Any<unknown, number>>(
        this: Text<number>,
        a1: T | Input<T>,
    ): Text<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Text<0 | 1>

textcat

  • textcat(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • textcat(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • textcat(this: Text<number>, a1: undefined | string | Text<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

texteq

  • texteq(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • texteq(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • texteq(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

texteqname

  • texteqname(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • texteqname(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • texteqname(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

textGe

  • textGe(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textGe(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textGe(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textgename

  • textgename(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • textgename(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • textgename(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

textGt

  • textGt(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textGt(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textGt(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textgtname

  • textgtname(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • textgtname(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • textgtname(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

texticlike

  • texticlike(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • texticlike(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • texticlike(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

texticnlike

  • texticnlike(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • texticnlike(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • texticnlike(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

texticregexeq

  • texticregexeq(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • texticregexeq(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • texticregexeq(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

texticregexne

  • texticregexne(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • texticregexne(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • texticregexne(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textLarger

  • textLarger(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • textLarger(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • textLarger(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

textLe

  • textLe(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textLe(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textLe(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textlen

  • textlen(this: Text<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • textlen(this: Text<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • textlen(this: Text<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

textlename

  • textlename(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • textlename(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • textlename(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

textlike

  • textlike(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textlike(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textlike(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textLt

  • textLt(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textLt(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textLt(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textltname

  • textltname(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • textltname(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • textltname(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

textne

  • textne(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textne(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textne(this: Text<number>, a1: undefined | string | Text<number>): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textnename

  • textnename(this: Text<1>, a1: Name<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • textnename(this: Text<0 | 1>, a1: Name<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • textnename(this: Text<number>, a1: Name<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

textnlike

  • textnlike(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textnlike(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textnlike(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textPatternGe

  • textPatternGe(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textPatternGe(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textPatternGe(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textPatternGt

  • textPatternGt(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textPatternGt(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textPatternGt(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textPatternLe

  • textPatternLe(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textPatternLe(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textPatternLe(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textPatternLt

  • textPatternLt(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textPatternLt(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textPatternLt(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textregexeq

  • textregexeq(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textregexeq(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textregexeq(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textregexne

  • textregexne(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • textregexne(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • textregexne(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

textSmaller

  • textSmaller(this: Text<1>, a1: undefined | string | Text<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Text<1>

  • textSmaller(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • textSmaller(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Text<0 | 1>

timezone

toAscii

  • toAscii(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • toAscii(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • toAscii(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • toAscii(this: Text<1>, a1: undefined | number | Int4<1>): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | number | Int4<1>

    Returns Text<1>

  • toAscii(this: Text<0 | 1>, a1: undefined | number | Int4<0 | 1>): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | number | Int4<0 | 1>

    Returns Text<0 | 1>

  • toAscii(this: Text<number>, a1: undefined | number | Int4<number>): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | number | Int4<number>

    Returns Text<0 | 1>

  • toAscii(this: Text<1>, a1: Name<1>): Text<1>

    Parameters

    Returns Text<1>

  • toAscii(this: Text<0 | 1>, a1: Name<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • toAscii(this: Text<number>, a1: Name<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

toDate

  • toDate(this: Text<1>, a1: undefined | string | Text<1>): Date<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Date<1>

  • toDate(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Date<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Date<0 | 1>

  • toDate(this: Text<number>, a1: undefined | string | Text<number>): Date<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Date<0 | 1>

toExpression

toJson

  • toJson<T extends Any<unknown, number>>(this: T): Json<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<1>

  • toJson<T extends Any<unknown, number>>(this: T): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

  • toJson<T extends Any<unknown, number>>(this: T): Json<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

toJsonb

  • toJsonb<T extends Any<unknown, number>>(this: T): Jsonb<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<1>

  • toJsonb<T extends Any<unknown, number>>(this: T): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

  • toJsonb<T extends Any<unknown, number>>(this: T): Jsonb<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

toNumber

  • toNumber(this: Text<1>, a1: undefined | string | Text<1>): Numeric<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Numeric<1>

  • toNumber(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Numeric<0 | 1>

  • toNumber(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Numeric<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Numeric<0 | 1>

toRegclass

  • toRegclass(this: Text<1>): Regclass<1>

    Parameters

    Returns Regclass<1>

  • toRegclass(this: Text<0 | 1>): Regclass<0 | 1>

    Parameters

    Returns Regclass<0 | 1>

  • toRegclass(this: Text<number>): Regclass<0 | 1>

    Parameters

    Returns Regclass<0 | 1>

toRegcollation

toRegnamespace

toRegoper

  • toRegoper(this: Text<1>): Regoper<1>

    Parameters

    Returns Regoper<1>

  • toRegoper(this: Text<0 | 1>): Regoper<0 | 1>

    Parameters

    Returns Regoper<0 | 1>

  • toRegoper(this: Text<number>): Regoper<0 | 1>

    Parameters

    Returns Regoper<0 | 1>

toRegoperator

toRegproc

  • toRegproc(this: Text<1>): Regproc<1>

    Parameters

    Returns Regproc<1>

  • toRegproc(this: Text<0 | 1>): Regproc<0 | 1>

    Parameters

    Returns Regproc<0 | 1>

  • toRegproc(this: Text<number>): Regproc<0 | 1>

    Parameters

    Returns Regproc<0 | 1>

toRegprocedure

toRegrole

  • toRegrole(this: Text<1>): Regrole<1>

    Parameters

    Returns Regrole<1>

  • toRegrole(this: Text<0 | 1>): Regrole<0 | 1>

    Parameters

    Returns Regrole<0 | 1>

  • toRegrole(this: Text<number>): Regrole<0 | 1>

    Parameters

    Returns Regrole<0 | 1>

toRegtype

  • toRegtype(this: Text<1>): Regtype<1>

    Parameters

    Returns Regtype<1>

  • toRegtype(this: Text<0 | 1>): Regtype<0 | 1>

    Parameters

    Returns Regtype<0 | 1>

  • toRegtype(this: Text<number>): Regtype<0 | 1>

    Parameters

    Returns Regtype<0 | 1>

toRegtypemod

  • toRegtypemod(this: Text<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • toRegtypemod(this: Text<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • toRegtypemod(this: Text<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

toTimestamp

  • toTimestamp(this: Text<1>, a1: undefined | string | Text<1>): Timestamptz<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Timestamptz<1>

  • toTimestamp(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Timestamptz<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Timestamptz<0 | 1>

  • toTimestamp(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Timestamptz<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Timestamptz<0 | 1>

toTsquery

  • toTsquery(this: Text<1>): Tsquery<1>

    Parameters

    Returns Tsquery<1>

  • toTsquery(this: Text<0 | 1>): Tsquery<0 | 1>

    Parameters

    Returns Tsquery<0 | 1>

  • toTsquery(this: Text<number>): Tsquery<0 | 1>

    Parameters

    Returns Tsquery<0 | 1>

toTsvector

  • toTsvector(this: Text<1>): Tsvector<1>

    Parameters

    Returns Tsvector<1>

  • toTsvector(this: Text<0 | 1>): Tsvector<0 | 1>

    Parameters

    Returns Tsvector<0 | 1>

  • toTsvector(this: Text<number>): Tsvector<0 | 1>

    Parameters

    Returns Tsvector<0 | 1>

translate

  • translate(
        this: Text<1>,
        a1: undefined | string | Text<1>,
        a2: undefined | string | Text<1>,
    ): Text<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>
    • a2: undefined | string | Text<1>

    Returns Text<1>

  • translate(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>
    • a2: undefined | string | Text<0 | 1>

    Returns Text<0 | 1>

  • translate(
        this: Text<number>,
        a1: undefined | string | Text<number>,
        a2: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>
    • a2: undefined | string | Text<number>

    Returns Text<0 | 1>

tsDebug

  • tsDebug(
        this: Text<1>,
    ): Setof<
        {
            from: {
                alias: Text<1>;
                description: Text<1>;
                dictionaries: Array<1, Regdictionary<0 | 1>>;
                dictionary: Regdictionary<1>;
                lexemes: Array<1, Text<0 | 1>>;
                token: Text<1>;
            };
        },
    >

    Parameters

    Returns Setof<
        {
            from: {
                alias: Text<1>;
                description: Text<1>;
                dictionaries: Array<1, Regdictionary<0 | 1>>;
                dictionary: Regdictionary<1>;
                lexemes: Array<1, Text<0 | 1>>;
                token: Text<1>;
            };
        },
    >

  • tsDebug(
        this: Text<0 | 1>,
    ): Setof<
        {
            from: {
                alias: Text<0 | 1>;
                description: Text<0 | 1>;
                dictionaries: Array<0 | 1, Regdictionary<0 | 1>>;
                dictionary: Regdictionary<0 | 1>;
                lexemes: Array<0 | 1, Text<0 | 1>>;
                token: Text<0 | 1>;
            };
        },
    >

    Parameters

    Returns Setof<
        {
            from: {
                alias: Text<0 | 1>;
                description: Text<0 | 1>;
                dictionaries: Array<0 | 1, Regdictionary<0 | 1>>;
                dictionary: Regdictionary<0 | 1>;
                lexemes: Array<0 | 1, Text<0 | 1>>;
                token: Text<0 | 1>;
            };
        },
    >

  • tsDebug(
        this: Text<number>,
    ): Setof<
        {
            from: {
                alias: Text<0 | 1>;
                description: Text<0 | 1>;
                dictionaries: Array<0 | 1, Regdictionary<0 | 1>>;
                dictionary: Regdictionary<0 | 1>;
                lexemes: Array<0 | 1, Text<0 | 1>>;
                token: Text<0 | 1>;
            };
        },
    >

    Parameters

    Returns Setof<
        {
            from: {
                alias: Text<0 | 1>;
                description: Text<0 | 1>;
                dictionaries: Array<0 | 1, Regdictionary<0 | 1>>;
                dictionary: Regdictionary<0 | 1>;
                lexemes: Array<0 | 1, Text<0 | 1>>;
                token: Text<0 | 1>;
            };
        },
    >

tsHeadline

  • tsHeadline(this: Text<1>, a1: Tsquery<1>): Text<1>

    Parameters

    Returns Text<1>

  • tsHeadline(this: Text<0 | 1>, a1: Tsquery<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • tsHeadline(this: Text<number>, a1: Tsquery<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • tsHeadline(
        this: Text<1>,
        a1: Tsquery<1>,
        a2: undefined | string | Text<1>,
    ): Text<1>

    Parameters

    Returns Text<1>

  • tsHeadline(
        this: Text<0 | 1>,
        a1: Tsquery<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • tsHeadline(
        this: Text<number>,
        a1: Tsquery<number>,
        a2: undefined | string | Text<number>,
    ): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

tsMatchTq

  • tsMatchTq(this: Text<1>, a1: Tsquery<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • tsMatchTq(this: Text<0 | 1>, a1: Tsquery<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • tsMatchTq(this: Text<number>, a1: Tsquery<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

tsMatchTt

  • tsMatchTt(this: Text<1>, a1: undefined | string | Text<1>): Bool<1>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Bool<1>

  • tsMatchTt(this: Text<0 | 1>, a1: undefined | string | Text<0 | 1>): Bool<0 | 1>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Bool<0 | 1>

  • tsMatchTt(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Bool<0 | 1>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Bool<0 | 1>

tsParse

  • tsParse(
        this: Text<1>,
        a1: undefined | string | Text<1>,
    ): Setof<{ from: { token: Text<1>; tokid: Int4<1> } }>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Setof<{ from: { token: Text<1>; tokid: Int4<1> } }>

  • tsParse(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Setof<{ from: { token: Text<0 | 1>; tokid: Int4<0 | 1> } }>

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Setof<{ from: { token: Text<0 | 1>; tokid: Int4<0 | 1> } }>

  • tsParse(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Setof<{ from: { token: Text<0 | 1>; tokid: Int4<0 | 1> } }>

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Setof<{ from: { token: Text<0 | 1>; tokid: Int4<0 | 1> } }>

tsStat

  • tsStat(
        this: Text<1>,
    ): Setof<{ from: { ndoc: Int4<1>; nentry: Int4<1>; word: Text<1> } }>

    Parameters

    Returns Setof<{ from: { ndoc: Int4<1>; nentry: Int4<1>; word: Text<1> } }>

  • tsStat(
        this: Text<0 | 1>,
    ): Setof<
        { from: { ndoc: Int4<0 | 1>; nentry: Int4<0 | 1>; word: Text<0 | 1> } },
    >

    Parameters

    Returns Setof<{ from: { ndoc: Int4<0 | 1>; nentry: Int4<0 | 1>; word: Text<0 | 1> } }>

  • tsStat(
        this: Text<number>,
    ): Setof<
        { from: { ndoc: Int4<0 | 1>; nentry: Int4<0 | 1>; word: Text<0 | 1> } },
    >

    Parameters

    Returns Setof<{ from: { ndoc: Int4<0 | 1>; nentry: Int4<0 | 1>; word: Text<0 | 1> } }>

  • tsStat(
        this: Text<1>,
        a1: undefined | string | Text<1>,
    ): Setof<{ from: { ndoc: Int4<1>; nentry: Int4<1>; word: Text<1> } }>

    Parameters

    • this: Text<1>
    • a1: undefined | string | Text<1>

    Returns Setof<{ from: { ndoc: Int4<1>; nentry: Int4<1>; word: Text<1> } }>

  • tsStat(
        this: Text<0 | 1>,
        a1: undefined | string | Text<0 | 1>,
    ): Setof<
        { from: { ndoc: Int4<0 | 1>; nentry: Int4<0 | 1>; word: Text<0 | 1> } },
    >

    Parameters

    • this: Text<0 | 1>
    • a1: undefined | string | Text<0 | 1>

    Returns Setof<{ from: { ndoc: Int4<0 | 1>; nentry: Int4<0 | 1>; word: Text<0 | 1> } }>

  • tsStat(
        this: Text<number>,
        a1: undefined | string | Text<number>,
    ): Setof<
        { from: { ndoc: Int4<0 | 1>; nentry: Int4<0 | 1>; word: Text<0 | 1> } },
    >

    Parameters

    • this: Text<number>
    • a1: undefined | string | Text<number>

    Returns Setof<{ from: { ndoc: Int4<0 | 1>; nentry: Int4<0 | 1>; word: Text<0 | 1> } }>

tsTokenType

  • tsTokenType(
        this: Text<1>,
    ): Setof<{ from: { alias: Text<1>; description: Text<1>; tokid: Int4<1> } }>

    Parameters

    Returns Setof<{ from: { alias: Text<1>; description: Text<1>; tokid: Int4<1> } }>

  • tsTokenType(
        this: Text<0 | 1>,
    ): Setof<
        {
            from: {
                alias: Text<0 | 1>;
                description: Text<0 | 1>;
                tokid: Int4<0 | 1>;
            };
        },
    >

    Parameters

    Returns Setof<
        {
            from: {
                alias: Text<0 | 1>;
                description: Text<0 | 1>;
                tokid: Int4<0 | 1>;
            };
        },
    >

  • tsTokenType(
        this: Text<number>,
    ): Setof<
        {
            from: {
                alias: Text<0 | 1>;
                description: Text<0 | 1>;
                tokid: Int4<0 | 1>;
            };
        },
    >

    Parameters

    Returns Setof<
        {
            from: {
                alias: Text<0 | 1>;
                description: Text<0 | 1>;
                tokid: Int4<0 | 1>;
            };
        },
    >

unicodeAssigned

  • unicodeAssigned(this: Text<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • unicodeAssigned(this: Text<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • unicodeAssigned(this: Text<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

unistr

  • unistr(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • unistr(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • unistr(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

upper

  • upper(this: Text<1>): Text<1>

    Parameters

    Returns Text<1>

  • upper(this: Text<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

  • upper(this: Text<number>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

websearchToTsquery

  • websearchToTsquery(this: Text<1>): Tsquery<1>

    Parameters

    Returns Tsquery<1>

  • websearchToTsquery(this: Text<0 | 1>): Tsquery<0 | 1>

    Parameters

    Returns Tsquery<0 | 1>

  • websearchToTsquery(this: Text<number>): Tsquery<0 | 1>

    Parameters

    Returns Tsquery<0 | 1>

widthBucket

  • widthBucket<T extends Any<unknown, number>>(this: T, a1: Array<1, T>): Int4<1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Int4<1>

  • widthBucket<T extends Any<unknown, number>>(
        this: T,
        a1: Array<0 | 1, T>,
    ): Int4<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Int4<0 | 1>

  • widthBucket<T extends Any<unknown, number>>(
        this: T,
        a1: Array<number, T>,
    ): Int4<0 | 1>

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Int4<0 | 1>

xml

  • xml(this: Text<1>): Xml<1>

    Parameters

    Returns Xml<1>

  • xml(this: Text<0 | 1>): Xml<0 | 1>

    Parameters

    Returns Xml<0 | 1>

  • xml(this: Text<number>): Xml<0 | 1>

    Parameters

    Returns Xml<0 | 1>

xmlcomment

  • xmlcomment(this: Text<1>): Xml<1>

    Parameters

    Returns Xml<1>

  • xmlcomment(this: Text<0 | 1>): Xml<0 | 1>

    Parameters

    Returns Xml<0 | 1>

  • xmlcomment(this: Text<number>): Xml<0 | 1>

    Parameters

    Returns Xml<0 | 1>

xmlexists

  • xmlexists(this: Text<1>, a1: Xml<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • xmlexists(this: Text<0 | 1>, a1: Xml<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • xmlexists(this: Text<number>, a1: Xml<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

xmlIsWellFormed

  • xmlIsWellFormed(this: Text<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • xmlIsWellFormed(this: Text<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • xmlIsWellFormed(this: Text<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

xmlIsWellFormedContent

  • xmlIsWellFormedContent(this: Text<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • xmlIsWellFormedContent(this: Text<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • xmlIsWellFormedContent(this: Text<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

xmlIsWellFormedDocument

  • xmlIsWellFormedDocument(this: Text<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • xmlIsWellFormedDocument(this: Text<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • xmlIsWellFormedDocument(this: Text<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

xmltext

  • xmltext(this: Text<1>): Xml<1>

    Parameters

    Returns Xml<1>

  • xmltext(this: Text<0 | 1>): Xml<0 | 1>

    Parameters

    Returns Xml<0 | 1>

  • xmltext(this: Text<number>): Xml<0 | 1>

    Parameters

    Returns Xml<0 | 1>

xpath

  • xpath(this: Text<1>, a1: Xml<1>): Array<1, Xml<0 | 1>>

    Parameters

    Returns Array<1, Xml<0 | 1>>

  • xpath(this: Text<0 | 1>, a1: Xml<0 | 1>): Array<0 | 1, Xml<0 | 1>>

    Parameters

    Returns Array<0 | 1, Xml<0 | 1>>

  • xpath(this: Text<number>, a1: Xml<number>): Array<0 | 1, Xml<0 | 1>>

    Parameters

    Returns Array<0 | 1, Xml<0 | 1>>

  • xpath(
        this: Text<1>,
        a1: Xml<1>,
        a2: Array<1, Text<0 | 1>>,
    ): Array<1, Xml<0 | 1>>

    Parameters

    Returns Array<1, Xml<0 | 1>>

  • xpath(
        this: Text<0 | 1>,
        a1: Xml<0 | 1>,
        a2: Array<0 | 1, Text<0 | 1>>,
    ): Array<0 | 1, Xml<0 | 1>>

    Parameters

    Returns Array<0 | 1, Xml<0 | 1>>

  • xpath(
        this: Text<number>,
        a1: Xml<number>,
        a2: Array<number, Text<0 | 1>>,
    ): Array<0 | 1, Xml<0 | 1>>

    Parameters

    Returns Array<0 | 1, Xml<0 | 1>>

xpathExists

  • xpathExists(this: Text<1>, a1: Xml<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • xpathExists(this: Text<0 | 1>, a1: Xml<0 | 1>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • xpathExists(this: Text<number>, a1: Xml<number>): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • xpathExists(this: Text<1>, a1: Xml<1>, a2: Array<1, Text<0 | 1>>): Bool<1>

    Parameters

    Returns Bool<1>

  • xpathExists(
        this: Text<0 | 1>,
        a1: Xml<0 | 1>,
        a2: Array<0 | 1, Text<0 | 1>>,
    ): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

  • xpathExists(
        this: Text<number>,
        a1: Xml<number>,
        a2: Array<number, Text<0 | 1>>,
    ): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

Staticnew

  • new(v: string): Text<1>

    Parameters

    • v: string

    Returns Text<1>

  • new(v: null): Text<0>

    Parameters

    • v: null

    Returns Text<0>

  • new(v: Expression): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

Staticparse

  • parse(v: string): string

    Parameters

    • v: string

    Returns string

Staticsubtype

  • subtype(): undefined | UseSubtype

    Returns undefined | UseSubtype

StatictypeString

  • typeString(): undefined | string

    Returns undefined | string

Settings

Member Visibility

On This Page

Constructors
Properties
Methods
!~!~*!~~!~~*@@^@<<@<=<>=>>=||~~*~<=~~<~~>=~~>~~~~~*anyValueanyValueTransfnarrayFillarrayPrependasAggregateasciibinaryUpgradeAddSubRelStatebinaryUpgradeCreateEmptyExtensionbinaryUpgradeReploriginAdvancebitLengthbtrimbttextcmpbttextnamecmpbttextPatternCmpcharcharacterLengthcharLengthconcatconcatWsconvertTocountcumeDistcurrentSettingcurrtid2datePartdateTruncdecodedenseRankelemContainedByMultirangeelemContainedByRangeexecuteextractfirstValueformatgetClassginCmpTslexemeginCompareJsonbhasAnyColumnPrivilegehasColumnPrivilegehasDatabasePrivilegehasForeignDataWrapperPrivilegehasFunctionPrivilegehashtexthashtextextendedhasLanguagePrivilegehasParameterPrivilegehasSchemaPrivilegehasSequencePrivilegehasServerPrivilegehasTablePrivilegehasTablespacePrivilegehasTypePrivilegeinitcapisNormalizedjsonAggjsonAggStrictjsonbAggjsonbAggStrictjsonbBuildArrayjsonbBuildObjectjsonbObjectAggjsonbObjectAggStrictjsonbObjectAggUniquejsonbObjectAggUniqueStrictjsonbPopulateRecordjsonbPopulateRecordsetjsonbPopulateRecordValidjsonBuildArrayjsonBuildObjectjsonObjectAggjsonObjectAggStrictjsonObjectAggUniquejsonObjectAggUniqueStrictjsonPopulateRecordjsonPopulateRecordsetlaglastValueleadleftlengthlikelikeEscapeloImportlowerlpadltrimmaxmd5modenamenormalizenotlikenthValuenumNonnullsnumNullsoctetLengthoverlayparseIdentpercentRankpgBackupStartpgCollationForpgColumnCompressionpgColumnSizepgColumnToastChunkIdpgCreateRestorePointpgCurrentLogfilepgGetObjectAddresspgGetSerialSequencepgGetViewdefpgInputErrorInfopgInputIsValidpgLsDirpgLsReplslotdirpgNotifypgReadBinaryFilepgReadFilepgReplicationOriginAdvancepgReplicationOriginCreatepgReplicationOriginDroppgReplicationOriginOidpgReplicationOriginProgresspgReplicationOriginSessionSetuppgSettingsGetFlagspgSizeBytespgSplitWalfileNamepgStatFilepgStatGetProgressInfopgStatGetReplicationSlotpgStatHaveStatspgStatResetReplicationSlotpgStatResetSharedpgStatResetSlrupgTypeofphrasetoTsqueryplaintoTsquerypositionqueryToXmlqueryToXmlAndXmlschemaqueryToXmlschemaquoteIdentquoteLiteralquoteNullablerankregclassregexpCountregexpInstrregexpLikeregexpMatchregexpMatchesregexpReplaceregexpSplitToArrayregexpSplitToTableregexpSubstrrepeatreplacereverserightrowSecurityActiverpadrtrimsetConfigsimilarEscapesimilarToEscapesplitPartstartsWithstringAggstringToArraystringToTablestrpossubstrsubstringtextanycattextcattexteqtexteqnametextGetextgenametextGttextgtnametexticliketexticnliketexticregexeqtexticregexnetextLargertextLetextlentextlenametextliketextLttextltnametextnetextnenametextnliketextPatternGetextPatternGttextPatternLetextPatternLttextregexeqtextregexnetextSmallertimezonetoAsciitoDatetoExpressiontoJsontoJsonbtoNumbertoRegclasstoRegcollationtoRegnamespacetoRegopertoRegoperatortoRegproctoRegproceduretoRegroletoRegtypetoRegtypemodtoTimestamptoTsquerytoTsvectortranslatetsDebugtsHeadlinetsMatchTqtsMatchTttsParsetsStattsTokenTypeunicodeAssignedunistrupperwebsearchToTsquerywidthBucketxmlxmlcommentxmlexistsxmlIsWellFormedxmlIsWellFormedContentxmlIsWellFormedDocumentxmltextxpathxpathExistsnewparsesubtypetypeString