Preparing search index...
The search index is not available
Typegres API Reference - v0.0.1
Typegres API Reference
Timestamptz
Class Timestamptz<N>
Type Parameters
N
extends
number
Hierarchy (
View Summary
)
Any
<
Parsed
,
N
>
Timestamptz
Index
Constructors
constructor
Properties
nullability
result
Type
serialize
Param
Types
v
Methods
-
+
<
<@
<=
<>
=
>
>=
||
age
any
Value
any
Value
Transfn
array
Fill
array
Prepend
as
Aggregate
concat
count
cume
Dist
date
date
Add
date
Subtract
dense
Rank
elem
Contained
By
Multirange
elem
Contained
By
Range
execute
first
Value
generate
Series
get
Class
in
Range
isfinite
json
Agg
json
Agg
Strict
jsonb
Agg
jsonb
Agg
Strict
jsonb
Build
Array
jsonb
Build
Object
jsonb
Object
Agg
jsonb
Object
Agg
Strict
jsonb
Object
Agg
Unique
jsonb
Object
Agg
Unique
Strict
jsonb
Populate
Record
jsonb
Populate
Recordset
jsonb
Populate
Record
Valid
json
Build
Array
json
Build
Object
json
Object
Agg
json
Object
Agg
Strict
json
Object
Agg
Unique
json
Object
Agg
Unique
Strict
json
Populate
Record
json
Populate
Recordset
lag
last
Value
lead
max
mode
nth
Value
num
Nonnulls
num
Nulls
overlaps
percent
Rank
pg
Collation
For
pg
Column
Compression
pg
Column
Size
pg
Column
Toast
Chunk
Id
pg
Sleep
Until
pg
Typeof
quote
Literal
quote
Nullable
rank
time
timestamp
timestamptz
timestamptz
Cmp
timestamptz
Cmp
Date
timestamptz
Cmp
Timestamp
timestamptz
Eq
timestamptz
Eq
Date
timestamptz
Eq
Timestamp
timestamptz
Ge
timestamptz
Ge
Date
timestamptz
Ge
Timestamp
timestamptz
Gt
timestamptz
Gt
Date
timestamptz
Gt
Timestamp
timestamptz
Larger
timestamptz
Le
timestamptz
Le
Date
timestamptz
Le
Timestamp
timestamptz
Lt
timestamptz
Lt
Date
timestamptz
Lt
Timestamp
timestamptz
Mi
timestamptz
Mi
Interval
timestamptz
Ne
timestamptz
Ne
Date
timestamptz
Ne
Timestamp
timestamptz
Pl
Interval
timestamptz
Smaller
timetz
timezone
to
Char
to
Expression
to
Json
to
Jsonb
tstzrange
tstzrange
Subdiff
width
Bucket
new
parse
subtype
type
String
Constructors
constructor
new
Timestamptz
<
N
extends
number
>
(
v
:
unknown
)
:
Timestamptz
<
N
>
Type Parameters
N
extends
number
Parameters
v
:
unknown
Returns
Timestamptz
<
N
>
Properties
nullability
nullability
:
undefined
|
N
= undefined
result
Type
resultType
:
undefined
|
string
= undefined
serialize
Param
Types
serializeParamTypes
:
unknown
= undefined
v
v
:
unknown
Methods
-
"-"
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Interval
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Interval
<
1
>
"-"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Interval
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Interval
<
0
|
1
>
"-"
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Interval
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Interval
<
0
|
1
>
"-"
(
this
:
Timestamptz
<
1
>
,
a1
:
Interval
<
1
>
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Interval
<
1
>
Returns
Timestamptz
<
1
>
"-"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Interval
<
0
|
1
>
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Interval
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
"-"
(
this
:
Timestamptz
<
number
>
,
a1
:
Interval
<
number
>
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Interval
<
number
>
Returns
Timestamptz
<
0
|
1
>
+
"+"
(
this
:
Timestamptz
<
1
>
,
a1
:
Interval
<
1
>
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Interval
<
1
>
Returns
Timestamptz
<
1
>
"+"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Interval
<
0
|
1
>
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Interval
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
"+"
(
this
:
Timestamptz
<
number
>
,
a1
:
Interval
<
number
>
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Interval
<
number
>
Returns
Timestamptz
<
0
|
1
>
<
"<"
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
"<"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"<"
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
"<"
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
"<"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"<"
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
"<"
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
"<"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"<"
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
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
this
:
T
a1
:
Anymultirange
<
1
,
T
>
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
this
:
T
a1
:
Anymultirange
<
0
|
1
,
T
>
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
this
:
T
a1
:
Anymultirange
<
number
,
T
>
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
this
:
T
a1
:
Anyrange
<
1
,
T
>
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
this
:
T
a1
:
Anyrange
<
0
|
1
,
T
>
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
this
:
T
a1
:
Anyrange
<
number
,
T
>
Returns
Bool
<
0
|
1
>
<=
"<="
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
"<="
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"<="
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
"<="
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
"<="
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"<="
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
"<="
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
"<="
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"<="
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Bool
<
0
|
1
>
<>
"<>"
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
"<>"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"<>"
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
"<>"
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
"<>"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"<>"
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
"<>"
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
"<>"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"<>"
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Bool
<
0
|
1
>
=
"="
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
"="
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"="
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
"="
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
"="
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"="
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
"="
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
"="
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
"="
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Bool
<
0
|
1
>
>
">"
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
">"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
">"
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
">"
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
">"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
">"
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
">"
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
">"
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
">"
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Bool
<
0
|
1
>
>=
">="
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
">="
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
">="
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
">="
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
">="
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
">="
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
">="
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
">="
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
">="
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
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
this
:
T
a1
:
Array
<
1
,
T
>
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
this
:
T
a1
:
Array
<
0
|
1
,
T
>
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
this
:
T
a1
:
Array
<
number
,
T
>
Returns
Array
<
0
|
1
,
T
>
age
age
(
this
:
Timestamptz
<
1
>
)
:
Interval
<
1
>
Parameters
this
:
Timestamptz
<
1
>
Returns
Interval
<
1
>
age
(
this
:
Timestamptz
<
0
|
1
>
)
:
Interval
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
Returns
Interval
<
0
|
1
>
age
(
this
:
Timestamptz
<
number
>
)
:
Interval
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
Returns
Interval
<
0
|
1
>
age
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Interval
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Interval
<
1
>
age
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Interval
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Interval
<
0
|
1
>
age
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Interval
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Interval
<
0
|
1
>
any
Value
anyValue
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
Returns
T
any
Value
Transfn
anyValueTransfn
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
T
|
Input
<
T
>
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
T
|
Input
<
T
>
Returns
T
anyValueTransfn
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
T
|
Input
<
T
>
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
T
|
Input
<
T
>
Returns
T
anyValueTransfn
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
T
|
Input
<
T
>
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
T
|
Input
<
T
>
Returns
T
array
Fill
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
this
:
T
a1
:
Array
<
1
,
Int4
<
0
|
1
>
>
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
this
:
T
a1
:
Array
<
0
|
1
,
Int4
<
0
|
1
>
>
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
this
:
T
a1
:
Array
<
number
,
Int4
<
0
|
1
>
>
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
this
:
T
a1
:
Array
<
1
,
Int4
<
0
|
1
>
>
a2
:
Array
<
1
,
Int4
<
0
|
1
>
>
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
this
:
T
a1
:
Array
<
0
|
1
,
Int4
<
0
|
1
>
>
a2
:
Array
<
0
|
1
,
Int4
<
0
|
1
>
>
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
this
:
T
a1
:
Array
<
number
,
Int4
<
0
|
1
>
>
a2
:
Array
<
number
,
Int4
<
0
|
1
>
>
Returns
Array
<
0
|
1
,
T
>
array
Prepend
arrayPrepend
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Array
<
1
,
T
>
,
)
:
Array
<
1
,
T
>
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Array
<
1
,
T
>
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
this
:
T
a1
:
Array
<
0
|
1
,
T
>
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
this
:
T
a1
:
Array
<
number
,
T
>
Returns
Array
<
0
|
1
,
T
>
as
Aggregate
asAggregate
()
:
undefined
|
Timestamptz
<
number
>
Returns
undefined
|
Timestamptz
<
number
>
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
>
cume
Dist
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
>
date
date
(
this
:
Timestamptz
<
1
>
)
:
Date
<
1
>
Parameters
this
:
Timestamptz
<
1
>
Returns
Date
<
1
>
date
(
this
:
Timestamptz
<
0
|
1
>
)
:
Date
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
Returns
Date
<
0
|
1
>
date
(
this
:
Timestamptz
<
number
>
)
:
Date
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
Returns
Date
<
0
|
1
>
date
Add
dateAdd
(
this
:
Timestamptz
<
1
>
,
a1
:
Interval
<
1
>
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Interval
<
1
>
Returns
Timestamptz
<
1
>
dateAdd
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Interval
<
0
|
1
>
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Interval
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
dateAdd
(
this
:
Timestamptz
<
number
>
,
a1
:
Interval
<
number
>
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Interval
<
number
>
Returns
Timestamptz
<
0
|
1
>
dateAdd
(
this
:
Timestamptz
<
1
>
,
a1
:
Interval
<
1
>
,
a2
:
undefined
|
string
|
Text
<
1
>
,
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Interval
<
1
>
a2
:
undefined
|
string
|
Text
<
1
>
Returns
Timestamptz
<
1
>
dateAdd
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Interval
<
0
|
1
>
,
a2
:
undefined
|
string
|
Text
<
0
|
1
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Interval
<
0
|
1
>
a2
:
undefined
|
string
|
Text
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
dateAdd
(
this
:
Timestamptz
<
number
>
,
a1
:
Interval
<
number
>
,
a2
:
undefined
|
string
|
Text
<
number
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Interval
<
number
>
a2
:
undefined
|
string
|
Text
<
number
>
Returns
Timestamptz
<
0
|
1
>
date
Subtract
dateSubtract
(
this
:
Timestamptz
<
1
>
,
a1
:
Interval
<
1
>
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Interval
<
1
>
Returns
Timestamptz
<
1
>
dateSubtract
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Interval
<
0
|
1
>
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Interval
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
dateSubtract
(
this
:
Timestamptz
<
number
>
,
a1
:
Interval
<
number
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Interval
<
number
>
Returns
Timestamptz
<
0
|
1
>
dateSubtract
(
this
:
Timestamptz
<
1
>
,
a1
:
Interval
<
1
>
,
a2
:
undefined
|
string
|
Text
<
1
>
,
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Interval
<
1
>
a2
:
undefined
|
string
|
Text
<
1
>
Returns
Timestamptz
<
1
>
dateSubtract
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Interval
<
0
|
1
>
,
a2
:
undefined
|
string
|
Text
<
0
|
1
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Interval
<
0
|
1
>
a2
:
undefined
|
string
|
Text
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
dateSubtract
(
this
:
Timestamptz
<
number
>
,
a1
:
Interval
<
number
>
,
a2
:
undefined
|
string
|
Text
<
number
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Interval
<
number
>
a2
:
undefined
|
string
|
Text
<
number
>
Returns
Timestamptz
<
0
|
1
>
dense
Rank
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
>
elem
Contained
By
Multirange
elemContainedByMultirange
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Anymultirange
<
1
,
T
>
,
)
:
Bool
<
1
>
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Anymultirange
<
1
,
T
>
Returns
Bool
<
1
>
elemContainedByMultirange
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Anymultirange
<
0
|
1
,
T
>
,
)
:
Bool
<
0
|
1
>
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Anymultirange
<
0
|
1
,
T
>
Returns
Bool
<
0
|
1
>
elemContainedByMultirange
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Anymultirange
<
number
,
T
>
,
)
:
Bool
<
0
|
1
>
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Anymultirange
<
number
,
T
>
Returns
Bool
<
0
|
1
>
elem
Contained
By
Range
elemContainedByRange
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Anyrange
<
1
,
T
>
,
)
:
Bool
<
1
>
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Anyrange
<
1
,
T
>
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
this
:
T
a1
:
Anyrange
<
0
|
1
,
T
>
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
this
:
T
a1
:
Anyrange
<
number
,
T
>
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
;
}
first
Value
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
generate
Series
generateSeries
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
,
a2
:
Interval
<
1
>
,
)
:
Setof
<
{
from
:
{}
}
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
a2
:
Interval
<
1
>
Returns
Setof
<
{
from
:
{}
}
>
generateSeries
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
,
a2
:
Interval
<
0
|
1
>
,
)
:
Setof
<
{
from
:
{}
}
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
a2
:
Interval
<
0
|
1
>
Returns
Setof
<
{
from
:
{}
}
>
generateSeries
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
,
a2
:
Interval
<
number
>
,
)
:
Setof
<
{
from
:
{}
}
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
a2
:
Interval
<
number
>
Returns
Setof
<
{
from
:
{}
}
>
generateSeries
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
,
a2
:
Interval
<
1
>
,
a3
:
undefined
|
string
|
Text
<
1
>
,
)
:
Setof
<
{
from
:
{}
}
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
a2
:
Interval
<
1
>
a3
:
undefined
|
string
|
Text
<
1
>
Returns
Setof
<
{
from
:
{}
}
>
generateSeries
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
,
a2
:
Interval
<
0
|
1
>
,
a3
:
undefined
|
string
|
Text
<
0
|
1
>
,
)
:
Setof
<
{
from
:
{}
}
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
a2
:
Interval
<
0
|
1
>
a3
:
undefined
|
string
|
Text
<
0
|
1
>
Returns
Setof
<
{
from
:
{}
}
>
generateSeries
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
,
a2
:
Interval
<
number
>
,
a3
:
undefined
|
string
|
Text
<
number
>
,
)
:
Setof
<
{
from
:
{}
}
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
a2
:
Interval
<
number
>
a3
:
undefined
|
string
|
Text
<
number
>
Returns
Setof
<
{
from
:
{}
}
>
get
Class
getClass
(
this
:
this
)
:
typeof
Any
Parameters
this
:
this
Returns
typeof
Any
in
Range
inRange
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
,
a2
:
Interval
<
1
>
,
a3
:
undefined
|
boolean
|
Bool
<
1
>
,
a4
:
undefined
|
boolean
|
Bool
<
1
>
,
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
a2
:
Interval
<
1
>
a3
:
undefined
|
boolean
|
Bool
<
1
>
a4
:
undefined
|
boolean
|
Bool
<
1
>
Returns
Bool
<
1
>
inRange
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
,
a2
:
Interval
<
0
|
1
>
,
a3
:
undefined
|
boolean
|
Bool
<
0
|
1
>
,
a4
:
undefined
|
boolean
|
Bool
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
a2
:
Interval
<
0
|
1
>
a3
:
undefined
|
boolean
|
Bool
<
0
|
1
>
a4
:
undefined
|
boolean
|
Bool
<
0
|
1
>
Returns
Bool
<
0
|
1
>
inRange
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
,
a2
:
Interval
<
number
>
,
a3
:
undefined
|
boolean
|
Bool
<
number
>
,
a4
:
undefined
|
boolean
|
Bool
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
a2
:
Interval
<
number
>
a3
:
undefined
|
boolean
|
Bool
<
number
>
a4
:
undefined
|
boolean
|
Bool
<
number
>
Returns
Bool
<
0
|
1
>
isfinite
isfinite
(
this
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
isfinite
(
this
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
isfinite
(
this
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
json
Agg
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
>
json
Agg
Strict
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
>
jsonb
Agg
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
>
jsonb
Agg
Strict
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
>
jsonb
Build
Array
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
>
jsonb
Build
Object
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
>
jsonb
Object
Agg
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
>
jsonb
Object
Agg
Strict
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
>
jsonb
Object
Agg
Unique
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
>
jsonb
Object
Agg
Unique
Strict
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
>
jsonb
Populate
Record
jsonbPopulateRecord
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Jsonb
<
1
>
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Jsonb
<
1
>
Returns
T
jsonbPopulateRecord
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Jsonb
<
0
|
1
>
,
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Jsonb
<
0
|
1
>
Returns
T
jsonbPopulateRecord
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Jsonb
<
number
>
,
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Jsonb
<
number
>
Returns
T
jsonb
Populate
Recordset
jsonbPopulateRecordset
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Jsonb
<
1
>
,
)
:
Setof
<
{
from
:
{}
}
>
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Jsonb
<
1
>
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
this
:
T
a1
:
Jsonb
<
0
|
1
>
Returns
Setof
<
{
from
:
{}
}
>
jsonbPopulateRecordset
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Jsonb
<
number
>
,
)
:
Setof
<
{
from
:
{}
}
>
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Jsonb
<
number
>
Returns
Setof
<
{
from
:
{}
}
>
jsonb
Populate
Record
Valid
jsonbPopulateRecordValid
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Jsonb
<
1
>
,
)
:
Bool
<
1
>
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Jsonb
<
1
>
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
this
:
T
a1
:
Jsonb
<
0
|
1
>
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
this
:
T
a1
:
Jsonb
<
number
>
Returns
Bool
<
0
|
1
>
json
Build
Array
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
>
json
Build
Object
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
>
json
Object
Agg
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
>
json
Object
Agg
Strict
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
>
json
Object
Agg
Unique
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
>
json
Object
Agg
Unique
Strict
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
>
json
Populate
Record
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
json
Populate
Recordset
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
this
:
T
a1
:
Int4
<
1
>
a2
:
T
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
this
:
T
a1
:
Int4
<
0
|
1
>
a2
:
T
Returns
T
lag
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Int4
<
number
>
,
a2
:
T
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Int4
<
number
>
a2
:
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
)
:
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
this
:
T
a1
:
Int4
<
1
>
Returns
T
lag
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Int4
<
0
|
1
>
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Int4
<
0
|
1
>
Returns
T
lag
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Int4
<
number
>
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Int4
<
number
>
Returns
T
last
Value
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
this
:
T
a1
:
Int4
<
1
>
a2
:
T
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
this
:
T
a1
:
Int4
<
0
|
1
>
a2
:
T
Returns
T
lead
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Int4
<
number
>
,
a2
:
T
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Int4
<
number
>
a2
:
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
)
:
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
this
:
T
a1
:
Int4
<
1
>
Returns
T
lead
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Int4
<
0
|
1
>
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Int4
<
0
|
1
>
Returns
T
lead
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Int4
<
number
>
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Int4
<
number
>
Returns
T
max
max
(
this
:
Timestamptz
<
number
>
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
Returns
Timestamptz
<
0
|
1
>
mode
mode
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
)
:
T
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
Returns
T
nth
Value
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
num
Nonnulls
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
>
num
Nulls
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
>
overlaps
overlaps
(
this
:
Timestamptz
<
1
>
,
a1
:
Interval
<
1
>
,
a2
:
Timestamptz
<
1
>
,
a3
:
Interval
<
1
>
,
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Interval
<
1
>
a2
:
Timestamptz
<
1
>
a3
:
Interval
<
1
>
Returns
Bool
<
1
>
overlaps
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Interval
<
0
|
1
>
,
a2
:
Timestamptz
<
0
|
1
>
,
a3
:
Interval
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Interval
<
0
|
1
>
a2
:
Timestamptz
<
0
|
1
>
a3
:
Interval
<
0
|
1
>
Returns
Bool
<
0
|
1
>
overlaps
(
this
:
Timestamptz
<
number
>
,
a1
:
Interval
<
number
>
,
a2
:
Timestamptz
<
number
>
,
a3
:
Interval
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Interval
<
number
>
a2
:
Timestamptz
<
number
>
a3
:
Interval
<
number
>
Returns
Bool
<
0
|
1
>
overlaps
(
this
:
Timestamptz
<
1
>
,
a1
:
Interval
<
1
>
,
a2
:
Timestamptz
<
1
>
,
a3
:
Timestamptz
<
1
>
,
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Interval
<
1
>
a2
:
Timestamptz
<
1
>
a3
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
overlaps
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Interval
<
0
|
1
>
,
a2
:
Timestamptz
<
0
|
1
>
,
a3
:
Timestamptz
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Interval
<
0
|
1
>
a2
:
Timestamptz
<
0
|
1
>
a3
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
overlaps
(
this
:
Timestamptz
<
number
>
,
a1
:
Interval
<
number
>
,
a2
:
Timestamptz
<
number
>
,
a3
:
Timestamptz
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Interval
<
number
>
a2
:
Timestamptz
<
number
>
a3
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
overlaps
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
,
a2
:
Timestamptz
<
1
>
,
a3
:
Interval
<
1
>
,
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
a2
:
Timestamptz
<
1
>
a3
:
Interval
<
1
>
Returns
Bool
<
1
>
overlaps
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
,
a2
:
Timestamptz
<
0
|
1
>
,
a3
:
Interval
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
a2
:
Timestamptz
<
0
|
1
>
a3
:
Interval
<
0
|
1
>
Returns
Bool
<
0
|
1
>
overlaps
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
,
a2
:
Timestamptz
<
number
>
,
a3
:
Interval
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
a2
:
Timestamptz
<
number
>
a3
:
Interval
<
number
>
Returns
Bool
<
0
|
1
>
overlaps
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
,
a2
:
Timestamptz
<
1
>
,
a3
:
Timestamptz
<
1
>
,
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
a2
:
Timestamptz
<
1
>
a3
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
overlaps
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
,
a2
:
Timestamptz
<
0
|
1
>
,
a3
:
Timestamptz
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
a2
:
Timestamptz
<
0
|
1
>
a3
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
overlaps
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
,
a2
:
Timestamptz
<
number
>
,
a3
:
Timestamptz
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
a2
:
Timestamptz
<
number
>
a3
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
percent
Rank
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
>
pg
Collation
For
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
>
pg
Column
Compression
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
>
pg
Column
Size
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
>
pg
Column
Toast
Chunk
Id
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
>
pg
Sleep
Until
pgSleepUntil
(
this
:
Timestamptz
<
1
>
)
:
Void
<
1
>
Parameters
this
:
Timestamptz
<
1
>
Returns
Void
<
1
>
pgSleepUntil
(
this
:
Timestamptz
<
0
|
1
>
)
:
Void
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
Returns
Void
<
0
|
1
>
pgSleepUntil
(
this
:
Timestamptz
<
number
>
)
:
Void
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
Returns
Void
<
0
|
1
>
pg
Typeof
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
>
quote
Literal
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
>
quote
Nullable
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
>
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
>
time
time
(
this
:
Timestamptz
<
1
>
)
:
Time
<
1
>
Parameters
this
:
Timestamptz
<
1
>
Returns
Time
<
1
>
time
(
this
:
Timestamptz
<
0
|
1
>
)
:
Time
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
Returns
Time
<
0
|
1
>
time
(
this
:
Timestamptz
<
number
>
)
:
Time
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
Returns
Time
<
0
|
1
>
timestamp
timestamp
(
this
:
Timestamptz
<
1
>
)
:
Timestamp
<
1
>
Parameters
this
:
Timestamptz
<
1
>
Returns
Timestamp
<
1
>
timestamp
(
this
:
Timestamptz
<
0
|
1
>
)
:
Timestamp
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
Returns
Timestamp
<
0
|
1
>
timestamp
(
this
:
Timestamptz
<
number
>
)
:
Timestamp
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
Returns
Timestamp
<
0
|
1
>
timestamptz
timestamptz
(
this
:
Timestamptz
<
1
>
,
a1
:
undefined
|
number
|
Int4
<
1
>
,
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
undefined
|
number
|
Int4
<
1
>
Returns
Timestamptz
<
1
>
timestamptz
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
undefined
|
number
|
Int4
<
0
|
1
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
undefined
|
number
|
Int4
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
timestamptz
(
this
:
Timestamptz
<
number
>
,
a1
:
undefined
|
number
|
Int4
<
number
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
undefined
|
number
|
Int4
<
number
>
Returns
Timestamptz
<
0
|
1
>
timestamptz
Cmp
timestamptzCmp
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Int4
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Int4
<
1
>
timestamptzCmp
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Int4
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Int4
<
0
|
1
>
timestamptzCmp
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Int4
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Int4
<
0
|
1
>
timestamptz
Cmp
Date
timestamptzCmpDate
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Int4
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Int4
<
1
>
timestamptzCmpDate
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Int4
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Int4
<
0
|
1
>
timestamptzCmpDate
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Int4
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Int4
<
0
|
1
>
timestamptz
Cmp
Timestamp
timestamptzCmpTimestamp
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Int4
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Int4
<
1
>
timestamptzCmpTimestamp
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
,
)
:
Int4
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Int4
<
0
|
1
>
timestamptzCmpTimestamp
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
,
)
:
Int4
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Int4
<
0
|
1
>
timestamptz
Eq
timestamptzEq
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
timestamptzEq
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzEq
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Eq
Date
timestamptzEqDate
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
timestamptzEqDate
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzEqDate
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Eq
Timestamp
timestamptzEqTimestamp
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
timestamptzEqTimestamp
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzEqTimestamp
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Ge
timestamptzGe
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
timestamptzGe
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzGe
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Ge
Date
timestamptzGeDate
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
timestamptzGeDate
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzGeDate
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Ge
Timestamp
timestamptzGeTimestamp
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
timestamptzGeTimestamp
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzGeTimestamp
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Gt
timestamptzGt
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
timestamptzGt
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzGt
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Gt
Date
timestamptzGtDate
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
timestamptzGtDate
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzGtDate
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Gt
Timestamp
timestamptzGtTimestamp
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
timestamptzGtTimestamp
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzGtTimestamp
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Larger
timestamptzLarger
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Timestamptz
<
1
>
timestamptzLarger
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
timestamptzLarger
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Timestamptz
<
0
|
1
>
timestamptz
Le
timestamptzLe
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
timestamptzLe
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzLe
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Le
Date
timestamptzLeDate
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
timestamptzLeDate
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzLeDate
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Le
Timestamp
timestamptzLeTimestamp
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
timestamptzLeTimestamp
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzLeTimestamp
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Lt
timestamptzLt
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
timestamptzLt
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzLt
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Lt
Date
timestamptzLtDate
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
timestamptzLtDate
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzLtDate
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Lt
Timestamp
timestamptzLtTimestamp
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
timestamptzLtTimestamp
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzLtTimestamp
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Mi
timestamptzMi
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Interval
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Interval
<
1
>
timestamptzMi
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Interval
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Interval
<
0
|
1
>
timestamptzMi
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
,
)
:
Interval
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Interval
<
0
|
1
>
timestamptz
Mi
Interval
timestamptzMiInterval
(
this
:
Timestamptz
<
1
>
,
a1
:
Interval
<
1
>
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Interval
<
1
>
Returns
Timestamptz
<
1
>
timestamptzMiInterval
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Interval
<
0
|
1
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Interval
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
timestamptzMiInterval
(
this
:
Timestamptz
<
number
>
,
a1
:
Interval
<
number
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Interval
<
number
>
Returns
Timestamptz
<
0
|
1
>
timestamptz
Ne
timestamptzNe
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Bool
<
1
>
timestamptzNe
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzNe
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Ne
Date
timestamptzNeDate
(
this
:
Timestamptz
<
1
>
,
a1
:
Date
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Date
<
1
>
Returns
Bool
<
1
>
timestamptzNeDate
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Date
<
0
|
1
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Date
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzNeDate
(
this
:
Timestamptz
<
number
>
,
a1
:
Date
<
number
>
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Date
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Ne
Timestamp
timestamptzNeTimestamp
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamp
<
1
>
)
:
Bool
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamp
<
1
>
Returns
Bool
<
1
>
timestamptzNeTimestamp
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamp
<
0
|
1
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamp
<
0
|
1
>
Returns
Bool
<
0
|
1
>
timestamptzNeTimestamp
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamp
<
number
>
,
)
:
Bool
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamp
<
number
>
Returns
Bool
<
0
|
1
>
timestamptz
Pl
Interval
timestamptzPlInterval
(
this
:
Timestamptz
<
1
>
,
a1
:
Interval
<
1
>
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Interval
<
1
>
Returns
Timestamptz
<
1
>
timestamptzPlInterval
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Interval
<
0
|
1
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Interval
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
timestamptzPlInterval
(
this
:
Timestamptz
<
number
>
,
a1
:
Interval
<
number
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Interval
<
number
>
Returns
Timestamptz
<
0
|
1
>
timestamptz
Smaller
timestamptzSmaller
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Timestamptz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Timestamptz
<
1
>
timestamptzSmaller
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Timestamptz
<
0
|
1
>
timestamptzSmaller
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
,
)
:
Timestamptz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Timestamptz
<
0
|
1
>
timetz
timetz
(
this
:
Timestamptz
<
1
>
)
:
Timetz
<
1
>
Parameters
this
:
Timestamptz
<
1
>
Returns
Timetz
<
1
>
timetz
(
this
:
Timestamptz
<
0
|
1
>
)
:
Timetz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
Returns
Timetz
<
0
|
1
>
timetz
(
this
:
Timestamptz
<
number
>
)
:
Timetz
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
Returns
Timetz
<
0
|
1
>
timezone
timezone
(
this
:
Timestamptz
<
1
>
)
:
Timestamp
<
1
>
Parameters
this
:
Timestamptz
<
1
>
Returns
Timestamp
<
1
>
timezone
(
this
:
Timestamptz
<
0
|
1
>
)
:
Timestamp
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
Returns
Timestamp
<
0
|
1
>
timezone
(
this
:
Timestamptz
<
number
>
)
:
Timestamp
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
Returns
Timestamp
<
0
|
1
>
to
Char
toChar
(
this
:
Timestamptz
<
1
>
,
a1
:
undefined
|
string
|
Text
<
1
>
)
:
Text
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
undefined
|
string
|
Text
<
1
>
Returns
Text
<
1
>
toChar
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
undefined
|
string
|
Text
<
0
|
1
>
,
)
:
Text
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
undefined
|
string
|
Text
<
0
|
1
>
Returns
Text
<
0
|
1
>
toChar
(
this
:
Timestamptz
<
number
>
,
a1
:
undefined
|
string
|
Text
<
number
>
,
)
:
Text
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
undefined
|
string
|
Text
<
number
>
Returns
Text
<
0
|
1
>
to
Expression
toExpression
()
:
Expression
Returns
Expression
to
Json
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
>
to
Jsonb
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
>
tstzrange
tstzrange
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Tstzrange
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Tstzrange
<
1
>
tstzrange
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
)
:
Tstzrange
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Tstzrange
<
0
|
1
>
tstzrange
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
)
:
Tstzrange
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Tstzrange
<
0
|
1
>
tstzrange
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
,
a2
:
undefined
|
string
|
Text
<
1
>
,
)
:
Tstzrange
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
a2
:
undefined
|
string
|
Text
<
1
>
Returns
Tstzrange
<
1
>
tstzrange
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
,
a2
:
undefined
|
string
|
Text
<
0
|
1
>
,
)
:
Tstzrange
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
a2
:
undefined
|
string
|
Text
<
0
|
1
>
Returns
Tstzrange
<
0
|
1
>
tstzrange
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
,
a2
:
undefined
|
string
|
Text
<
number
>
,
)
:
Tstzrange
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
a2
:
undefined
|
string
|
Text
<
number
>
Returns
Tstzrange
<
0
|
1
>
tstzrange
Subdiff
tstzrangeSubdiff
(
this
:
Timestamptz
<
1
>
,
a1
:
Timestamptz
<
1
>
)
:
Float8
<
1
>
Parameters
this
:
Timestamptz
<
1
>
a1
:
Timestamptz
<
1
>
Returns
Float8
<
1
>
tstzrangeSubdiff
(
this
:
Timestamptz
<
0
|
1
>
,
a1
:
Timestamptz
<
0
|
1
>
,
)
:
Float8
<
0
|
1
>
Parameters
this
:
Timestamptz
<
0
|
1
>
a1
:
Timestamptz
<
0
|
1
>
Returns
Float8
<
0
|
1
>
tstzrangeSubdiff
(
this
:
Timestamptz
<
number
>
,
a1
:
Timestamptz
<
number
>
,
)
:
Float8
<
0
|
1
>
Parameters
this
:
Timestamptz
<
number
>
a1
:
Timestamptz
<
number
>
Returns
Float8
<
0
|
1
>
width
Bucket
widthBucket
<
T
extends
Any
<
unknown
,
number
>
>
(
this
:
T
,
a1
:
Array
<
1
,
T
>
)
:
Int4
<
1
>
Type Parameters
T
extends
Any
<
unknown
,
number
>
Parameters
this
:
T
a1
:
Array
<
1
,
T
>
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
this
:
T
a1
:
Array
<
0
|
1
,
T
>
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
this
:
T
a1
:
Array
<
number
,
T
>
Returns
Int4
<
0
|
1
>
Static
new
new
(
v
:
string
)
:
Timestamptz
<
1
>
Parameters
v
:
string
Returns
Timestamptz
<
1
>
new
(
v
:
null
)
:
Timestamptz
<
0
>
Parameters
v
:
null
Returns
Timestamptz
<
0
>
new
(
v
:
Expression
)
:
Timestamptz
<
0
|
1
>
Parameters
v
:
Expression
Returns
Timestamptz
<
0
|
1
>
Static
parse
parse
(
v
:
string
)
:
string
Parameters
v
:
string
Returns
string
Static
subtype
subtype
()
:
undefined
|
UseSubtype
Returns
undefined
|
UseSubtype
Static
type
String
typeString
()
:
undefined
|
string
Returns
undefined
|
string
Settings
Member Visibility
Inherited
External
Theme
OS
Light
Dark
On This Page
Constructors
constructor
Properties
nullability
result
Type
serialize
Param
Types
v
Methods
-
+
<
<@
<=
<>
=
>
>=
||
age
any
Value
any
Value
Transfn
array
Fill
array
Prepend
as
Aggregate
concat
count
cume
Dist
date
date
Add
date
Subtract
dense
Rank
elem
Contained
By
Multirange
elem
Contained
By
Range
execute
first
Value
generate
Series
get
Class
in
Range
isfinite
json
Agg
json
Agg
Strict
jsonb
Agg
jsonb
Agg
Strict
jsonb
Build
Array
jsonb
Build
Object
jsonb
Object
Agg
jsonb
Object
Agg
Strict
jsonb
Object
Agg
Unique
jsonb
Object
Agg
Unique
Strict
jsonb
Populate
Record
jsonb
Populate
Recordset
jsonb
Populate
Record
Valid
json
Build
Array
json
Build
Object
json
Object
Agg
json
Object
Agg
Strict
json
Object
Agg
Unique
json
Object
Agg
Unique
Strict
json
Populate
Record
json
Populate
Recordset
lag
last
Value
lead
max
mode
nth
Value
num
Nonnulls
num
Nulls
overlaps
percent
Rank
pg
Collation
For
pg
Column
Compression
pg
Column
Size
pg
Column
Toast
Chunk
Id
pg
Sleep
Until
pg
Typeof
quote
Literal
quote
Nullable
rank
time
timestamp
timestamptz
timestamptz
Cmp
timestamptz
Cmp
Date
timestamptz
Cmp
Timestamp
timestamptz
Eq
timestamptz
Eq
Date
timestamptz
Eq
Timestamp
timestamptz
Ge
timestamptz
Ge
Date
timestamptz
Ge
Timestamp
timestamptz
Gt
timestamptz
Gt
Date
timestamptz
Gt
Timestamp
timestamptz
Larger
timestamptz
Le
timestamptz
Le
Date
timestamptz
Le
Timestamp
timestamptz
Lt
timestamptz
Lt
Date
timestamptz
Lt
Timestamp
timestamptz
Mi
timestamptz
Mi
Interval
timestamptz
Ne
timestamptz
Ne
Date
timestamptz
Ne
Timestamp
timestamptz
Pl
Interval
timestamptz
Smaller
timetz
timezone
to
Char
to
Expression
to
Json
to
Jsonb
tstzrange
tstzrange
Subdiff
width
Bucket
new
parse
subtype
type
String
Typegres API Reference - v0.0.1
Loading...