Typegres API Reference - v0.2.0
Preparing search index...
Bytea
Class Bytea<N>
Type Parameters
in out
N
extends
number
Hierarchy (
View Summary
)
Anynonarray
<
N
>
Bytea
Index
Constructors
constructor
Properties
[meta]
deserialize
__
typname
__
typname
Text
Methods
!~~
<
<=
<>
=
>
>=
||
~~
any
Value
any
Value
Transfn
array
Agg
array
Prepend
bit
Count
bit
Length
btrim
byteacat
bytealike
byteanlike
byteasend
cast
coalesce
count
cume
Dist
dense
Rank
elem
Contained
By
Multirange
elem
Contained
By
Range
encode
eq
get
Bit
get
Byte
gt
gte
in
is
Not
Null
is
Null
json
Agg
json
Agg
Strict
jsonb
Agg
jsonb
Agg
Strict
jsonb
Object
Agg
jsonb
Object
Agg
Strict
jsonb
Object
Agg
Unique
jsonb
Object
Agg
Unique
Strict
json
Object
Agg
json
Object
Agg
Strict
json
Object
Agg
Unique
json
Object
Agg
Unique
Strict
length
like
like
Escape
lt
lte
ltrim
md5
mode
ne
notlike
num
Nonnulls
num
Nulls
octet
Length
overlay
percent
Rank
position
rank
rtrim
set
Bit
set
Byte
sha224
sha256
sha384
sha512
string
Agg
substr
substring
to
Sql
column
from
serialize
Constructors
constructor
new
Bytea
<
in out
N
extends
number
>
()
:
Bytea
<
N
>
Type Parameters
in out
N
extends
number
Returns
Bytea
<
N
>
Properties
[meta]
"[meta]"
:
{
__aggregate
:
Bytea
<
number
>
;
__any
:
Bytea
<
any
>
;
__class
:
typeof
Bytea
;
__nonNullable
:
Bytea
<
1
>
;
__nullability
:
N
;
__nullable
:
Bytea
<
0
|
1
>
;
__raw
:
Sql
;
}
deserialize
deserialize
:
(
raw
:
string
)
=>
string
Static
__
typname
__typname
:
Raw
= ...
Static
__
typname
Text
__typnameText
:
string
= "bytea"
Methods
!~~
"!~~"
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
<
"<"
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
<=
"<="
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
<>
"<>"
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
=
"="
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
>
">"
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
>=
">="
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
||
"||"
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
~~
"~~"
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
any
Value
anyValue
()
:
Anyelement
<
0
|
1
>
Returns
Anyelement
<
0
|
1
>
any
Value
Transfn
anyValueTransfn
<
M0
extends
Anyelement
<
any
>
>
(
arg0
:
M0
,
)
:
Anyelement
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
Anyelement
<
any
>
Parameters
arg0
:
M0
Returns
Anyelement
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
array
Agg
arrayAgg
()
:
Anyarray
<
Any
<
any
>
,
0
|
1
>
Returns
Anyarray
<
Any
<
any
>
,
0
|
1
>
array
Prepend
arrayPrepend
<
M0
extends
Anycompatiblearray
<
Any
<
any
>
,
any
>
>
(
arg0
:
M0
,
)
:
Anycompatiblearray
<
Any
<
any
>
,
1
>
Type Parameters
M0
extends
Anycompatiblearray
<
Any
<
any
>
,
any
>
Parameters
arg0
:
M0
Returns
Anycompatiblearray
<
Any
<
any
>
,
1
>
bit
Count
bitCount
()
:
Int8
<
N
>
Returns
Int8
<
N
>
bit
Length
bitLength
()
:
Int4
<
N
>
Returns
Int4
<
N
>
btrim
btrim
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
byteacat
byteacat
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
bytealike
bytealike
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
byteanlike
byteanlike
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
byteasend
byteasend
()
:
Bytea
<
N
>
Returns
Bytea
<
N
>
cast
cast
<
T
extends
typeof
Any
>
(
cls
:
T
,
)
:
[
number
]
extends
[
N
]
?
InstanceType
<
T
>
extends
{
"[meta]"
:
{
__aggregate
:
U
}
}
?
U
:
InstanceType
<
T
>
:
[
N
]
extends
[
1
]
?
InstanceType
<
T
>
extends
{
"[meta]"
:
{
__nonNullable
:
U
}
}
?
U
:
InstanceType
<
T
>
:
InstanceType
<
T
>
extends
{
"[meta]"
:
{
__nullable
:
U
}
}
?
U
:
InstanceType
<
T
>
Type Parameters
T
extends
typeof
Any
Parameters
cls
:
T
Returns
[
number
]
extends
[
N
]
?
InstanceType
<
T
>
extends
{
"[meta]"
:
{
__aggregate
:
U
}
}
?
U
:
InstanceType
<
T
>
:
[
N
]
extends
[
1
]
?
InstanceType
<
T
>
extends
{
"[meta]"
:
{
__nonNullable
:
U
}
}
?
U
:
InstanceType
<
T
>
:
InstanceType
<
T
>
extends
{
"[meta]"
:
{
__nullable
:
U
}
}
?
U
:
InstanceType
<
T
>
coalesce
coalesce
<
T
extends
Any
<
any
>
,
R
extends
Any
<
any
>
>
(
this
:
T
,
rhs
:
R
,
)
:
0
extends
NullOf
<
R
>
?
T
:
T
extends
{
"[meta]"
:
{
__nonNullable
:
U
}
}
?
U
:
T
Type Parameters
T
extends
Any
<
any
>
R
extends
Any
<
any
>
Parameters
this
:
T
rhs
:
R
Returns
0
extends
NullOf
<
R
>
?
T
:
T
extends
{
"[meta]"
:
{
__nonNullable
:
U
}
}
?
U
:
T
count
count
()
:
Int8
<
1
>
Returns
Int8
<
1
>
cume
Dist
cumeDist
()
:
Float8
<
0
|
1
>
Returns
Float8
<
0
|
1
>
dense
Rank
denseRank
()
:
Int8
<
0
|
1
>
Returns
Int8
<
0
|
1
>
elem
Contained
By
Multirange
elemContainedByMultirange
<
M0
extends
Anymultirange
<
Any
<
any
>
,
any
>
>
(
arg0
:
M0
,
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
Anymultirange
<
Any
<
any
>
,
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
elem
Contained
By
Range
elemContainedByRange
<
M0
extends
Anyrange
<
Any
<
any
>
,
any
>
>
(
arg0
:
M0
,
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
Anyrange
<
Any
<
any
>
,
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
encode
encode
<
M0
extends
string
|
Text
<
any
>
>
(
arg0
:
M0
,
)
:
Text
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Text
<
any
>
Parameters
arg0
:
M0
Returns
Text
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
eq
eq
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
get
Bit
getBit
<
M0
extends
string
|
Int8
<
any
>
>
(
arg0
:
M0
,
)
:
Int4
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Int8
<
any
>
Parameters
arg0
:
M0
Returns
Int4
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
get
Byte
getByte
<
M0
extends
number
|
Int4
<
any
>
>
(
arg0
:
M0
,
)
:
Int4
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
number
|
Int4
<
any
>
Parameters
arg0
:
M0
Returns
Int4
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
gt
gt
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
gte
gte
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
in
in
<
T
extends
Any
<
any
>
,
Vs
extends
[
(
T
extends
{
"[meta]"
:
{
__any
:
A
}
}
?
A
:
Any
<
any
>
)
|
TsTypeOf
<
T
>
,
...
(
TsTypeOf
<
T
>
|
(
T
extends
{
"[meta]"
:
{
__any
:
A
}
}
?
A
:
Any
<
any
>
))
[]
,
]
,
>
(
this
:
T
,
...
vals
:
Vs
,
)
:
Bool
<
StrictNull
<
NullOf
<
T
>
|
NullOf
<
Vs
[
number
]
>
>
>
Type Parameters
T
extends
Any
<
any
>
Vs
extends
[
(
T
extends
{
"[meta]"
:
{
__any
:
A
}
}
?
A
:
Any
<
any
>
)
|
TsTypeOf
<
T
>
,
...
(
TsTypeOf
<
T
>
|
(
T
extends
{
"[meta]"
:
{
__any
:
A
}
}
?
A
:
Any
<
any
>
))
[]
,
]
Parameters
this
:
T
...
vals
:
Vs
Returns
Bool
<
StrictNull
<
NullOf
<
T
>
|
NullOf
<
Vs
[
number
]
>
>
>
is
Not
Null
isNotNull
()
:
Bool
<
1
>
Returns
Bool
<
1
>
is
Null
isNull
()
:
Bool
<
1
>
Returns
Bool
<
1
>
json
Agg
jsonAgg
()
:
Json
<
0
|
1
>
Returns
Json
<
0
|
1
>
json
Agg
Strict
jsonAggStrict
()
:
Json
<
0
|
1
>
Returns
Json
<
0
|
1
>
jsonb
Agg
jsonbAgg
()
:
Jsonb
<
0
|
1
>
Returns
Jsonb
<
0
|
1
>
jsonb
Agg
Strict
jsonbAggStrict
()
:
Jsonb
<
0
|
1
>
Returns
Jsonb
<
0
|
1
>
jsonb
Object
Agg
jsonbObjectAgg
<
M0
extends
string
|
Any
<
any
>
>
(
arg0
:
M0
)
:
Jsonb
<
0
|
1
>
Type Parameters
M0
extends
string
|
Any
<
any
>
Parameters
arg0
:
M0
Returns
Jsonb
<
0
|
1
>
jsonb
Object
Agg
Strict
jsonbObjectAggStrict
<
M0
extends
string
|
Any
<
any
>
>
(
arg0
:
M0
)
:
Jsonb
<
0
|
1
>
Type Parameters
M0
extends
string
|
Any
<
any
>
Parameters
arg0
:
M0
Returns
Jsonb
<
0
|
1
>
jsonb
Object
Agg
Unique
jsonbObjectAggUnique
<
M0
extends
string
|
Any
<
any
>
>
(
arg0
:
M0
)
:
Jsonb
<
0
|
1
>
Type Parameters
M0
extends
string
|
Any
<
any
>
Parameters
arg0
:
M0
Returns
Jsonb
<
0
|
1
>
jsonb
Object
Agg
Unique
Strict
jsonbObjectAggUniqueStrict
<
M0
extends
string
|
Any
<
any
>
>
(
arg0
:
M0
)
:
Jsonb
<
0
|
1
>
Type Parameters
M0
extends
string
|
Any
<
any
>
Parameters
arg0
:
M0
Returns
Jsonb
<
0
|
1
>
json
Object
Agg
jsonObjectAgg
<
M0
extends
string
|
Any
<
any
>
>
(
arg0
:
M0
)
:
Json
<
0
|
1
>
Type Parameters
M0
extends
string
|
Any
<
any
>
Parameters
arg0
:
M0
Returns
Json
<
0
|
1
>
json
Object
Agg
Strict
jsonObjectAggStrict
<
M0
extends
string
|
Any
<
any
>
>
(
arg0
:
M0
)
:
Json
<
0
|
1
>
Type Parameters
M0
extends
string
|
Any
<
any
>
Parameters
arg0
:
M0
Returns
Json
<
0
|
1
>
json
Object
Agg
Unique
jsonObjectAggUnique
<
M0
extends
string
|
Any
<
any
>
>
(
arg0
:
M0
)
:
Json
<
0
|
1
>
Type Parameters
M0
extends
string
|
Any
<
any
>
Parameters
arg0
:
M0
Returns
Json
<
0
|
1
>
json
Object
Agg
Unique
Strict
jsonObjectAggUniqueStrict
<
M0
extends
string
|
Any
<
any
>
>
(
arg0
:
M0
)
:
Json
<
0
|
1
>
Type Parameters
M0
extends
string
|
Any
<
any
>
Parameters
arg0
:
M0
Returns
Json
<
0
|
1
>
length
length
()
:
Int4
<
N
>
Returns
Int4
<
N
>
like
like
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
like
Escape
likeEscape
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
lt
lt
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
lte
lte
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
ltrim
ltrim
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
md5
md5
()
:
Text
<
N
>
Returns
Text
<
N
>
mode
mode
()
:
Anyelement
<
0
|
1
>
Returns
Anyelement
<
0
|
1
>
ne
ne
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
notlike
notlike
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bool
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
num
Nonnulls
numNonnulls
()
:
Int4
<
1
>
Returns
Int4
<
1
>
num
Nulls
numNulls
()
:
Int4
<
1
>
Returns
Int4
<
1
>
octet
Length
octetLength
()
:
Int4
<
N
>
Returns
Int4
<
N
>
overlay
overlay
<
M0
extends
string
|
Bytea
<
any
>
,
M1
extends
number
|
Int4
<
any
>
,
M2
extends
number
|
Int4
<
any
>
,
>
(
arg0
:
M0
,
arg1
:
M1
,
arg2
:
M2
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
|
NullOf
<
M2
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
M1
extends
number
|
Int4
<
any
>
M2
extends
number
|
Int4
<
any
>
Parameters
arg0
:
M0
arg1
:
M1
arg2
:
M2
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
|
NullOf
<
M2
>
>
>
overlay
<
M0
extends
string
|
Bytea
<
any
>
,
M1
extends
number
|
Int4
<
any
>
>
(
arg0
:
M0
,
arg1
:
M1
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
M1
extends
number
|
Int4
<
any
>
Parameters
arg0
:
M0
arg1
:
M1
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
>
>
percent
Rank
percentRank
()
:
Float8
<
0
|
1
>
Returns
Float8
<
0
|
1
>
position
position
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Int4
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Int4
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
rank
rank
()
:
Int8
<
0
|
1
>
Returns
Int8
<
0
|
1
>
rtrim
rtrim
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
set
Bit
setBit
<
M0
extends
string
|
Int8
<
any
>
,
M1
extends
number
|
Int4
<
any
>
>
(
arg0
:
M0
,
arg1
:
M1
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
>
>
Type Parameters
M0
extends
string
|
Int8
<
any
>
M1
extends
number
|
Int4
<
any
>
Parameters
arg0
:
M0
arg1
:
M1
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
>
>
set
Byte
setByte
<
M0
extends
number
|
Int4
<
any
>
,
M1
extends
number
|
Int4
<
any
>
>
(
arg0
:
M0
,
arg1
:
M1
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
>
>
Type Parameters
M0
extends
number
|
Int4
<
any
>
M1
extends
number
|
Int4
<
any
>
Parameters
arg0
:
M0
arg1
:
M1
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
>
>
sha224
sha224
()
:
Bytea
<
N
>
Returns
Bytea
<
N
>
sha256
sha256
()
:
Bytea
<
N
>
Returns
Bytea
<
N
>
sha384
sha384
()
:
Bytea
<
N
>
Returns
Bytea
<
N
>
sha512
sha512
()
:
Bytea
<
N
>
Returns
Bytea
<
N
>
string
Agg
stringAgg
<
M0
extends
string
|
Bytea
<
any
>
>
(
arg0
:
M0
)
:
Bytea
<
0
|
1
>
Type Parameters
M0
extends
string
|
Bytea
<
any
>
Parameters
arg0
:
M0
Returns
Bytea
<
0
|
1
>
substr
substr
<
M0
extends
number
|
Int4
<
any
>
>
(
arg0
:
M0
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
number
|
Int4
<
any
>
Parameters
arg0
:
M0
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
substr
<
M0
extends
number
|
Int4
<
any
>
,
M1
extends
number
|
Int4
<
any
>
>
(
arg0
:
M0
,
arg1
:
M1
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
>
>
Type Parameters
M0
extends
number
|
Int4
<
any
>
M1
extends
number
|
Int4
<
any
>
Parameters
arg0
:
M0
arg1
:
M1
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
>
>
substring
substring
<
M0
extends
number
|
Int4
<
any
>
,
M1
extends
number
|
Int4
<
any
>
>
(
arg0
:
M0
,
arg1
:
M1
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
>
>
Type Parameters
M0
extends
number
|
Int4
<
any
>
M1
extends
number
|
Int4
<
any
>
Parameters
arg0
:
M0
arg1
:
M1
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
|
NullOf
<
M1
>
>
>
substring
<
M0
extends
number
|
Int4
<
any
>
>
(
arg0
:
M0
,
)
:
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
Type Parameters
M0
extends
number
|
Int4
<
any
>
Parameters
arg0
:
M0
Returns
Bytea
<
StrictNull
<
N
|
NullOf
<
M0
>
>
>
to
Sql
toSql
()
:
Sql
Returns
Sql
Static
column
column
<
T
extends
typeof
Any
,
Opts
extends
ColumnOpts
=
{}
>
(
this
:
T
,
_opts
?:
Opts
,
)
:
InstanceType
<
T
>
&
{
"[meta]"
:
{
__required
:
Opts
extends
{
nonNull
:
true
}
?
Opts
extends
{
default
:
any
}
|
{
generated
:
true
}
?
false
:
true
:
false
;
}
;
}
Type Parameters
T
extends
typeof
Any
Opts
extends
ColumnOpts
=
{}
Parameters
this
:
T
Optional
_opts
:
Opts
Returns
InstanceType
<
T
>
&
{
"[meta]"
:
{
__required
:
Opts
extends
{
nonNull
:
true
}
?
Opts
extends
{
default
:
any
}
|
{
generated
:
true
}
?
false
:
true
:
false
;
}
;
}
Static
from
from
<
T
extends
typeof
Any
>
(
this
:
T
,
v
:
Sql
,
)
:
InstanceType
<
T
>
extends
{
"[meta]"
:
{
__nullable
:
U
}
}
?
U
:
InstanceType
<
T
>
Type Parameters
T
extends
typeof
Any
Parameters
this
:
T
v
:
Sql
Returns
InstanceType
<
T
>
extends
{
"[meta]"
:
{
__nullable
:
U
}
}
?
U
:
InstanceType
<
T
>
from
<
T
extends
typeof
Any
>
(
this
:
T
,
v
:
unknown
,
)
:
InstanceType
<
T
>
extends
{
"[meta]"
:
{
__nonNullable
:
U
}
}
?
U
:
InstanceType
<
T
>
Type Parameters
T
extends
typeof
Any
Parameters
this
:
T
v
:
unknown
Returns
InstanceType
<
T
>
extends
{
"[meta]"
:
{
__nonNullable
:
U
}
}
?
U
:
InstanceType
<
T
>
Static
serialize
serialize
(
v
:
unknown
)
:
Any
<
any
>
Parameters
v
:
unknown
Returns
Any
<
any
>
Settings
Member Visibility
Inherited
External
Theme
OS
Light
Dark
On This Page
Constructors
constructor
Properties
[meta]
deserialize
__
typname
__
typname
Text
Methods
!~~
<
<=
<>
=
>
>=
||
~~
any
Value
any
Value
Transfn
array
Agg
array
Prepend
bit
Count
bit
Length
btrim
byteacat
bytealike
byteanlike
byteasend
cast
coalesce
count
cume
Dist
dense
Rank
elem
Contained
By
Multirange
elem
Contained
By
Range
encode
eq
get
Bit
get
Byte
gt
gte
in
is
Not
Null
is
Null
json
Agg
json
Agg
Strict
jsonb
Agg
jsonb
Agg
Strict
jsonb
Object
Agg
jsonb
Object
Agg
Strict
jsonb
Object
Agg
Unique
jsonb
Object
Agg
Unique
Strict
json
Object
Agg
json
Object
Agg
Strict
json
Object
Agg
Unique
json
Object
Agg
Unique
Strict
length
like
like
Escape
lt
lte
ltrim
md5
mode
ne
notlike
num
Nonnulls
num
Nulls
octet
Length
overlay
percent
Rank
position
rank
rtrim
set
Bit
set
Byte
sha224
sha256
sha384
sha512
string
Agg
substr
substring
to
Sql
column
from
serialize
Typegres API Reference - v0.2.0
Loading...