Type Parameters

  • N extends number

Hierarchy (View Summary)

  • Any<Parsed, N>
    • Timestamp

Constructors

Properties

Methods

- + < <@ <= <> = > >= || age anyValue anyValueTransfn arrayFill arrayPrepend asAggregate asNonNullable asNullable cast coalesce concat count cumeDist date denseRank elemContainedByMultirange elemContainedByRange eq execute firstValue generateSeries getClass gt gte in inRange isDistinctFrom isfinite isNotDistinctFrom isNotNull isNull jsonAgg jsonAggStrict jsonbAgg jsonbAggStrict jsonbBuildArray jsonbBuildObject jsonbObjectAgg jsonbObjectAggStrict jsonbObjectAggUnique jsonbObjectAggUniqueStrict jsonbPopulateRecord jsonbPopulateRecordset jsonbPopulateRecordValid jsonBuildArray jsonBuildObject jsonObjectAgg jsonObjectAggStrict jsonObjectAggUnique jsonObjectAggUniqueStrict jsonPopulateRecord jsonPopulateRecordset lag lastValue lead lt lte max minus mode ne notIn nthValue numNonnulls numNulls over overlaps percentRank pgCollationFor pgColumnCompression pgColumnSize pgColumnToastChunkId pgTypeof plus quoteLiteral quoteNullable rank time timestamp timestampCmp timestampCmpDate timestampCmpTimestamptz timestampEq timestampEqDate timestampEqTimestamptz timestampGe timestampGeDate timestampGeTimestamptz timestampGt timestampGtDate timestampGtTimestamptz timestampHash timestampHashExtended timestampLarger timestampLe timestampLeDate timestampLeTimestamptz timestampLt timestampLtDate timestampLtTimestamptz timestampMi timestampMiInterval timestampNe timestampNeDate timestampNeTimestamptz timestampPlInterval timestampSmaller timestamptz timezone toChar toExpression toJson toJsonb tsrange tsrangeSubdiff widthBucket new parse subtype typeString

Constructors

  • Type Parameters

    • N extends number

    Parameters

    • v: unknown

    Returns Timestamp<N>

Properties

nullability: undefined | N = undefined
resultType: undefined | string = undefined
serializeParamTypes: unknown = undefined
v: unknown

Methods

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Array<0 | 1, T>

  • SQL CAST operator - converts a value to a different type CAST(expression AS target_type)

    Type Parameters

    • N extends number
    • T extends {
          prototype: Any<any, any>;
          new(v: null): Any<unknown, 0>;
          new(v: Expression): Any<unknown, 0 | 1>;
          new(v: unknown): Any<unknown, 1>;
          parse(v: string): unknown;
          subtype(): undefined | UseSubtype;
          typeString(): undefined | string;
          new (v: unknown): Any<unknown, N>;
      }

    Parameters

    • this: Any<unknown, N>
    • targetType: T

    Returns WithNullability<N, ReturnType<T["new"]>>

  • Type Parameters

    • T extends Any<unknown, number>
    • T2 extends Any<unknown, 0 | 1>
    • F extends unknown

    Parameters

    • this: T
    • fallback: F

    Returns T extends Any<unknown, 1>
        ? T<T>
        : F extends Any<unknown, number> ? F<F> : MakeNonNullable<T2>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 1>[]

    Returns Text<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 0 | 1>[]

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int8<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Float8<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Int8<0 | 1>

  • Parameters

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

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Parameters

    • this: this

    Returns typeof Any

  • SQL IN operator - checks if value is in a list or subquery result value IN (1, 2, 3) or value IN (SELECT ...)

    Type Parameters

    Parameters

    Returns Bool<N>

  • SQL IN operator - checks if value is in a list or subquery result value IN (1, 2, 3) or value IN (SELECT ...)

    Type Parameters

    • K extends string
    • T extends Any<unknown, 0 | 1>

    Parameters

    • list: Select<{ [k in string]: T }>

    Returns Bool<N>

  • Parameters

    Returns Bool<1>

  • Parameters

    Returns Bool<0 | 1>

  • Parameters

    Returns Bool<0 | 1>

  • SQL IS DISTINCT FROM operator - null-safe inequality comparison Returns true when values are different, treating NULL as a known value NULL IS DISTINCT FROM NULL = false NULL IS DISTINCT FROM value = true value IS DISTINCT FROM value = false

    Type Parameters

    • R2
    • N2 extends number

    Parameters

    Returns Bool<1>

  • SQL IS NOT DISTINCT FROM operator - null-safe equality comparison Returns true when values are the same, treating NULL as a known value NULL IS NOT DISTINCT FROM NULL = true NULL IS NOT DISTINCT FROM value = false value IS NOT DISTINCT FROM value = true

    Type Parameters

    • R2
    • N2 extends number

    Parameters

    Returns Bool<1>

  • SQL IS NOT NULL operator - checks if the value is not null

    Returns Bool<1>

  • SQL IS NULL operator - checks if the value is null

    Returns Bool<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 1>[]

    Returns Jsonb<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 0 | 1>[]

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 1>[]

    Returns Jsonb<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 0 | 1>[]

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<unknown, number>

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<unknown, number>

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<unknown, number>

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<unknown, number>

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Bool<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 1>[]

    Returns Json<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 0 | 1>[]

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 1>[]

    Returns Json<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 0 | 1>[]

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<unknown, number>

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<unknown, number>

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<unknown, number>

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • a1: Any<unknown, number>

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

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

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

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

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

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

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

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

    Returns FromItem<{}>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

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

    Returns FromItem<{}>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

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

    Returns FromItem<{}>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns T

  • SQL NOT IN operator - checks if value is not in a list or subquery result value NOT IN (1, 2, 3) or value NOT IN (SELECT ...)

    Type Parameters

    Parameters

    Returns Bool<N>

  • SQL NOT IN operator - checks if value is not in a list or subquery result value NOT IN (1, 2, 3) or value NOT IN (SELECT ...)

    Type Parameters

    • K extends string
    • T extends Any<unknown, 0 | 1>

    Parameters

    • list: Select<{ [k in string]: T }>

    Returns Bool<N>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

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

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

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

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

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

    Returns T

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 1>[]

    Returns Int4<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 0 | 1>[]

    Returns Int4<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Int4<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 1>[]

    Returns Int4<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, 0 | 1>[]

    Returns Int4<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Int4<0 | 1>

  • SQL OVER clause - converts an aggregate function to a window function Can be used with partition by and order by specifications

    Parameters

    Returns this

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Float8<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Int4<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Oid<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Oid<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Oid<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Regtype<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Regtype<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Regtype<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T
    • ...variadic: Any<unknown, number>[]

    Returns Int8<0 | 1>

  • Parameters

    Returns Timestamp<1>

  • Parameters

    Returns Timestamp<0 | 1>

  • Parameters

    Returns Timestamp<0 | 1>

  • Parameters

    Returns Int4<1>

  • Parameters

    Returns Int4<0 | 1>

  • Parameters

    Returns Int4<0 | 1>

  • Parameters

    Returns Int8<1>

  • Parameters

    Returns Int8<0 | 1>

  • Parameters

    Returns Int8<0 | 1>

  • Parameters

    Returns Text<1>

  • Parameters

    Returns Text<0 | 1>

  • Parameters

    Returns Text<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Json<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    • this: T

    Returns Jsonb<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Int4<1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Int4<0 | 1>

  • Type Parameters

    • T extends Any<unknown, number>

    Parameters

    Returns Int4<0 | 1>

  • Parameters

    • v: string

    Returns string

  • Returns undefined | UseSubtype

  • Returns undefined | string