Class Numeric<N>

Type Parameters

  • N extends number

Hierarchy (View Summary)

  • Any<Parsed, N>
    • Numeric

Constructors

constructor

Properties

nullability resultType serializeParamTypes v serializeParamTypes

Methods

- * / % ^ + < <@ <= <> = > >= || abs anyValue anyValueTransfn arrayFill arrayPrepend asAggregate avg ceil ceiling concat count cumeDist denseRank div elemContainedByMultirange elemContainedByRange execute exp firstValue float4 float8 floor gcd generateSeries getClass hashNumeric hashNumericExtended inRange int2 int4 int8 int8Sum jsonAgg jsonAggStrict jsonbAgg jsonbAggStrict jsonbBuildArray jsonbBuildObject jsonbObjectAgg jsonbObjectAggStrict jsonbObjectAggUnique jsonbObjectAggUniqueStrict jsonbPopulateRecord jsonbPopulateRecordset jsonbPopulateRecordValid jsonBuildArray jsonBuildObject jsonObjectAgg jsonObjectAggStrict jsonObjectAggUnique jsonObjectAggUniqueStrict jsonPopulateRecord jsonPopulateRecordset lag lastValue lcm lead ln log log10 max minScale mod mode money nthValue numeric numericAbs numericAdd numericCmp numericDiv numericDivTrunc numericEq numericExp numericGe numericGt numericInc numericLarger numericLe numericLn numericLog numericLt numericMod numericMul numericNe numericPlPgLsn numericPower numericSmaller numericSqrt numericSub numericUminus numericUplus numNonnulls numNulls numrange numrangeSubdiff percentRank pgCollationFor pgColumnCompression pgColumnSize pgColumnToastChunkId pgLsn pgSizePretty pgTypeof pow power quoteLiteral quoteNullable random rank round scale sign sqrt stddev stddevPop stddevSamp sum toChar toExpression toJson toJsonb trimScale trunc variance varPop varSamp widthBucket new parse subtype typeString

Constructors

constructor

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

    Type Parameters

    • N extends number

    Parameters

    • v: unknown

    Returns Numeric<N>

Properties

nullability

nullability: undefined | N = undefined

resultType

resultType: undefined | string = undefined

serializeParamTypes

serializeParamTypes: unknown = undefined

v

v: unknown

StaticserializeParamTypes

serializeParamTypes: undefined | readonly (string | number | bigint)[] = undefined

Methods

-

  • "-"(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • "-"(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

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

    Parameters

    Returns Numeric<0 | 1>

*

  • "*"(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

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

    Parameters

    Returns Numeric<0 | 1>

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

    Parameters

    Returns Numeric<0 | 1>

/

  • "/"(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • "/"(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

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

    Parameters

    Returns Numeric<0 | 1>

%

  • "%"(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • "%"(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

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

    Parameters

    Returns Numeric<0 | 1>

^

  • "^"(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

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

    Parameters

    Returns Numeric<0 | 1>

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

    Parameters

    Returns Numeric<0 | 1>

+

<

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

    Parameters

    Returns Bool<1>

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

    Parameters

    Returns Bool<0 | 1>

  • "<"(
        this: Numeric<number>,
        a1: undefined | string | Numeric<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: Numeric<1>, a1: undefined | string | Numeric<1>): Bool<1>

    Parameters

    Returns Bool<1>

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

    Parameters

    Returns Bool<0 | 1>

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

    Parameters

    Returns Bool<0 | 1>

<>

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

    Parameters

    Returns Bool<1>

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

    Parameters

    Returns Bool<0 | 1>

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

    Parameters

    Returns Bool<0 | 1>

=

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

    Parameters

    Returns Bool<1>

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

    Parameters

    Returns Bool<0 | 1>

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

    Parameters

    Returns Bool<0 | 1>

>

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

    Parameters

    Returns Bool<1>

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

    Parameters

    Returns Bool<0 | 1>

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

    Parameters

    Returns Bool<0 | 1>

>=

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

    Parameters

    Returns Bool<1>

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

    Parameters

    Returns Bool<0 | 1>

  • ">="(
        this: Numeric<number>,
        a1: undefined | string | Numeric<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>

abs

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

avg

ceil

ceiling

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>

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>

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>

div

  • div(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • div(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • div(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

elemContainedByMultirange

elemContainedByRange

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;
    }

exp

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

float4

float8

floor

gcd

  • gcd(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • gcd(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • gcd(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

generateSeries

  • generateSeries(
        this: Numeric<1>,
        a1: undefined | string | Numeric<1>,
    ): Setof<{ from: {} }>

    Parameters

    Returns Setof<{ from: {} }>

  • generateSeries(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Setof<{ from: {} }>

    Parameters

    Returns Setof<{ from: {} }>

  • generateSeries(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Setof<{ from: {} }>

    Parameters

    Returns Setof<{ from: {} }>

  • generateSeries(
        this: Numeric<1>,
        a1: undefined | string | Numeric<1>,
        a2: undefined | string | Numeric<1>,
    ): Setof<{ from: {} }>

    Parameters

    Returns Setof<{ from: {} }>

  • generateSeries(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
        a2: undefined | string | Numeric<0 | 1>,
    ): Setof<{ from: {} }>

    Parameters

    Returns Setof<{ from: {} }>

  • generateSeries(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
        a2: undefined | string | Numeric<number>,
    ): Setof<{ from: {} }>

    Parameters

    Returns Setof<{ from: {} }>

getClass

  • getClass(this: this): typeof Any

    Parameters

    • this: this

    Returns typeof Any

hashNumeric

  • hashNumeric(this: Numeric<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • hashNumeric(this: Numeric<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • hashNumeric(this: Numeric<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

hashNumericExtended

  • hashNumericExtended(this: Numeric<1>, a1: undefined | bigint | Int8<1>): Int8<1>

    Parameters

    Returns Int8<1>

  • hashNumericExtended(
        this: Numeric<0 | 1>,
        a1: undefined | bigint | Int8<0 | 1>,
    ): Int8<0 | 1>

    Parameters

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

    Returns Int8<0 | 1>

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

    Parameters

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

    Returns Int8<0 | 1>

inRange

  • inRange(
        this: Numeric<1>,
        a1: undefined | string | Numeric<1>,
        a2: undefined | string | Numeric<1>,
        a3: undefined | boolean | Bool<1>,
        a4: undefined | boolean | Bool<1>,
    ): Bool<1>

    Parameters

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

    Returns Bool<1>

  • inRange(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
        a2: undefined | string | Numeric<0 | 1>,
        a3: undefined | boolean | Bool<0 | 1>,
        a4: undefined | boolean | Bool<0 | 1>,
    ): Bool<0 | 1>

    Parameters

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

    Returns Bool<0 | 1>

  • inRange(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
        a2: undefined | string | Numeric<number>,
        a3: undefined | boolean | Bool<number>,
        a4: undefined | boolean | Bool<number>,
    ): Bool<0 | 1>

    Parameters

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

    Returns Bool<0 | 1>

int2

  • int2(this: Numeric<1>): Int2<1>

    Parameters

    Returns Int2<1>

  • int2(this: Numeric<0 | 1>): Int2<0 | 1>

    Parameters

    Returns Int2<0 | 1>

  • int2(this: Numeric<number>): Int2<0 | 1>

    Parameters

    Returns Int2<0 | 1>

int4

  • int4(this: Numeric<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • int4(this: Numeric<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • int4(this: Numeric<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

int8

  • int8(this: Numeric<1>): Int8<1>

    Parameters

    Returns Int8<1>

  • int8(this: Numeric<0 | 1>): Int8<0 | 1>

    Parameters

    Returns Int8<0 | 1>

  • int8(this: Numeric<number>): Int8<0 | 1>

    Parameters

    Returns Int8<0 | 1>

int8Sum

  • int8Sum(this: Numeric<1>, a1: undefined | bigint | Int8<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • int8Sum(
        this: Numeric<0 | 1>,
        a1: undefined | bigint | Int8<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

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

    Returns Numeric<0 | 1>

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

    Parameters

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

    Returns Numeric<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

lcm

  • lcm(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • lcm(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • lcm(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

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

ln

log

log10

max

minScale

  • minScale(this: Numeric<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • minScale(this: Numeric<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • minScale(this: Numeric<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

mod

  • mod(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • mod(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • mod(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

mode

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

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

money

  • money(this: Numeric<1>): Money<1>

    Parameters

    Returns Money<1>

  • money(this: Numeric<0 | 1>): Money<0 | 1>

    Parameters

    Returns Money<0 | 1>

  • money(this: Numeric<number>): Money<0 | 1>

    Parameters

    Returns Money<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

numeric

  • numeric(this: Numeric<1>, a1: undefined | number | Int4<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numeric(
        this: Numeric<0 | 1>,
        a1: undefined | number | Int4<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

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

    Returns Numeric<0 | 1>

  • numeric(
        this: Numeric<number>,
        a1: undefined | number | Int4<number>,
    ): Numeric<0 | 1>

    Parameters

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

    Returns Numeric<0 | 1>

numericAbs

numericAdd

  • numericAdd(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numericAdd(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • numericAdd(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

numericCmp

  • numericCmp(this: Numeric<1>, a1: undefined | string | Numeric<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • numericCmp(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

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

    Parameters

    Returns Int4<0 | 1>

numericDiv

  • numericDiv(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numericDiv(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • numericDiv(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

numericDivTrunc

  • numericDivTrunc(
        this: Numeric<1>,
        a1: undefined | string | Numeric<1>,
    ): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numericDivTrunc(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • numericDivTrunc(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

numericEq

  • numericEq(this: Numeric<1>, a1: undefined | string | Numeric<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • numericEq(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

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

    Parameters

    Returns Bool<0 | 1>

numericExp

numericGe

  • numericGe(this: Numeric<1>, a1: undefined | string | Numeric<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • numericGe(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

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

    Parameters

    Returns Bool<0 | 1>

numericGt

  • numericGt(this: Numeric<1>, a1: undefined | string | Numeric<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • numericGt(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

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

    Parameters

    Returns Bool<0 | 1>

numericInc

numericLarger

  • numericLarger(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numericLarger(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • numericLarger(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

numericLe

  • numericLe(this: Numeric<1>, a1: undefined | string | Numeric<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • numericLe(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

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

    Parameters

    Returns Bool<0 | 1>

numericLn

numericLog

  • numericLog(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numericLog(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • numericLog(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

numericLt

  • numericLt(this: Numeric<1>, a1: undefined | string | Numeric<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • numericLt(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

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

    Parameters

    Returns Bool<0 | 1>

numericMod

  • numericMod(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numericMod(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • numericMod(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

numericMul

  • numericMul(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numericMul(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • numericMul(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

numericNe

  • numericNe(this: Numeric<1>, a1: undefined | string | Numeric<1>): Bool<1>

    Parameters

    Returns Bool<1>

  • numericNe(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Bool<0 | 1>

    Parameters

    Returns Bool<0 | 1>

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

    Parameters

    Returns Bool<0 | 1>

numericPlPgLsn

numericPower

  • numericPower(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numericPower(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • numericPower(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

numericSmaller

  • numericSmaller(
        this: Numeric<1>,
        a1: undefined | string | Numeric<1>,
    ): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numericSmaller(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • numericSmaller(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

numericSqrt

numericSub

  • numericSub(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • numericSub(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • numericSub(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

numericUminus

numericUplus

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>

numrange

  • numrange(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numrange<1>

    Parameters

    Returns Numrange<1>

  • numrange(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numrange<0 | 1>

    Parameters

    Returns Numrange<0 | 1>

  • numrange(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numrange<0 | 1>

    Parameters

    Returns Numrange<0 | 1>

  • numrange(
        this: Numeric<1>,
        a1: undefined | string | Numeric<1>,
        a2: undefined | string | Text<1>,
    ): Numrange<1>

    Parameters

    Returns Numrange<1>

  • numrange(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
        a2: undefined | string | Text<0 | 1>,
    ): Numrange<0 | 1>

    Parameters

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

    Returns Numrange<0 | 1>

  • numrange(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
        a2: undefined | string | Text<number>,
    ): Numrange<0 | 1>

    Parameters

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

    Returns Numrange<0 | 1>

numrangeSubdiff

  • numrangeSubdiff(
        this: Numeric<1>,
        a1: undefined | string | Numeric<1>,
    ): Float8<1>

    Parameters

    Returns Float8<1>

  • numrangeSubdiff(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Float8<0 | 1>

    Parameters

    Returns Float8<0 | 1>

  • numrangeSubdiff(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Float8<0 | 1>

    Parameters

    Returns Float8<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>

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>

pgLsn

  • pgLsn(this: Numeric<1>): PgLsn<1>

    Parameters

    Returns PgLsn<1>

  • pgLsn(this: Numeric<0 | 1>): PgLsn<0 | 1>

    Parameters

    Returns PgLsn<0 | 1>

  • pgLsn(this: Numeric<number>): PgLsn<0 | 1>

    Parameters

    Returns PgLsn<0 | 1>

pgSizePretty

  • pgSizePretty(this: Numeric<1>): Text<1>

    Parameters

    Returns Text<1>

  • pgSizePretty(this: Numeric<0 | 1>): Text<0 | 1>

    Parameters

    Returns Text<0 | 1>

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

    Parameters

    Returns Text<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>

pow

  • pow(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • pow(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • pow(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

power

  • power(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • power(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • power(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

quoteLiteral

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

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<1>

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

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

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

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

quoteNullable

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

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<1>

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

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

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

    Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

random

  • random(this: Numeric<1>, a1: undefined | string | Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • random(
        this: Numeric<0 | 1>,
        a1: undefined | string | Numeric<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • random(
        this: Numeric<number>,
        a1: undefined | string | Numeric<number>,
    ): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

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>

round

  • round(this: Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • round(this: Numeric<0 | 1>): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • round(this: Numeric<number>): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • round(this: Numeric<1>, a1: undefined | number | Int4<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • round(
        this: Numeric<0 | 1>,
        a1: undefined | number | Int4<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

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

    Returns Numeric<0 | 1>

  • round(
        this: Numeric<number>,
        a1: undefined | number | Int4<number>,
    ): Numeric<0 | 1>

    Parameters

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

    Returns Numeric<0 | 1>

scale

  • scale(this: Numeric<1>): Int4<1>

    Parameters

    Returns Int4<1>

  • scale(this: Numeric<0 | 1>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

  • scale(this: Numeric<number>): Int4<0 | 1>

    Parameters

    Returns Int4<0 | 1>

sign

sqrt

stddev

stddevPop

stddevSamp

sum

toChar

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

    Parameters

    Returns Text<1>

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

    Parameters

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

    Returns Text<0 | 1>

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

    Parameters

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

    Returns Text<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>

trimScale

trunc

  • trunc(this: Numeric<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • trunc(this: Numeric<0 | 1>): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • trunc(this: Numeric<number>): Numeric<0 | 1>

    Parameters

    Returns Numeric<0 | 1>

  • trunc(this: Numeric<1>, a1: undefined | number | Int4<1>): Numeric<1>

    Parameters

    Returns Numeric<1>

  • trunc(
        this: Numeric<0 | 1>,
        a1: undefined | number | Int4<0 | 1>,
    ): Numeric<0 | 1>

    Parameters

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

    Returns Numeric<0 | 1>

  • trunc(
        this: Numeric<number>,
        a1: undefined | number | Int4<number>,
    ): Numeric<0 | 1>

    Parameters

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

    Returns Numeric<0 | 1>

variance

varPop

varSamp

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>

Staticnew

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
-*/%^+<<@<=<>=>>=||absanyValueanyValueTransfnarrayFillarrayPrependasAggregateavgceilceilingconcatcountcumeDistdenseRankdivelemContainedByMultirangeelemContainedByRangeexecuteexpfirstValuefloat4float8floorgcdgenerateSeriesgetClasshashNumerichashNumericExtendedinRangeint2int4int8int8SumjsonAggjsonAggStrictjsonbAggjsonbAggStrictjsonbBuildArrayjsonbBuildObjectjsonbObjectAggjsonbObjectAggStrictjsonbObjectAggUniquejsonbObjectAggUniqueStrictjsonbPopulateRecordjsonbPopulateRecordsetjsonbPopulateRecordValidjsonBuildArrayjsonBuildObjectjsonObjectAggjsonObjectAggStrictjsonObjectAggUniquejsonObjectAggUniqueStrictjsonPopulateRecordjsonPopulateRecordsetlaglastValuelcmleadlnloglog10maxminScalemodmodemoneynthValuenumericnumericAbsnumericAddnumericCmpnumericDivnumericDivTruncnumericEqnumericExpnumericGenumericGtnumericIncnumericLargernumericLenumericLnnumericLognumericLtnumericModnumericMulnumericNenumericPlPgLsnnumericPowernumericSmallernumericSqrtnumericSubnumericUminusnumericUplusnumNonnullsnumNullsnumrangenumrangeSubdiffpercentRankpgCollationForpgColumnCompressionpgColumnSizepgColumnToastChunkIdpgLsnpgSizePrettypgTypeofpowpowerquoteLiteralquoteNullablerandomrankroundscalesignsqrtstddevstddevPopstddevSampsumtoChartoExpressiontoJsontoJsonbtrimScaletruncvariancevarPopvarSampwidthBucketnewparsesubtypetypeString