We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
OPERATOR(...)
OPERATOR(+)
OPERATOR(schema.table.|//)
~
foo[1]
foo[1:5]
foo[2:]
foo[:5]
foo[:]
CAST(expr AS type)
expr::type
type(expr)
float8(125)
type 'string'
TIME (6) WITH TIME ZONE '15:30'
VARCHAR(100) 'Hello'
OR
AND
NOT
>
<
>=
<=
=
<>
!=
[NOT] BETWEEN ... AND ...
[NOT] BETWEEN SYMMETRIC ... AND ...
IS [NOT] DISTINCT FROM
IS [NOT] {NULL | TRUE | FALSE | UNKNOWN}
ISNULL
NOTNULL
+
-
*
/
%
^
|/
||/
@
&
|
>>
<<
#
||
IS [NOT] [form] NORMALIZED
^@
[NOT] LIKE
[NOT] ILIKE
ESCAPE
SIMILAR TO
!~
~*
!~*
~~
!~~
~~*
!~~*
->
->>
#>
#>>
@>
<@
?
?|
?&
#-
@?
@@
EXISTS
[NOT] IN
ANY
SOME
ALL
EXTRACT(... FROM ...)
AT TIME ZONE
:=
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Operators
OPERATOR(...)
syntax, likeOPERATOR(+)
orOPERATOR(schema.table.|//)
~
can be both a unary or binary operator (bitwise negation or string match)foo[1]
foo[1:5]
,foo[2:]
,foo[:5]
,foo[:]
CAST(expr AS type)
expr::type
type(expr)
e.g.float8(125)
type 'string'
e.g.TIME (6) WITH TIME ZONE '15:30'
orVARCHAR(100) 'Hello'
OR
,AND
,NOT
>
,<
,>=
,<=
,=
,<>
,!=
[NOT] BETWEEN ... AND ...
[NOT] BETWEEN SYMMETRIC ... AND ...
IS [NOT] DISTINCT FROM
IS [NOT] {NULL | TRUE | FALSE | UNKNOWN}
ISNULL
NOTNULL
+
-
~
+
,-
,*
,/
%
^
|/
,||/
,@
,&
,|
,>>
,<<
#
works as bitwise XOR, not as comment||
IS [NOT] [form] NORMALIZED
^@
[NOT] LIKE
[NOT] ILIKE
ESCAPE
with LIKE & ILIKESIMILAR TO
ESCAPE
with SIMILAR TO~
,!~
,~*
,!~*
,~~
,!~~
,~~*
,!~~*
->
,->>
,#>
,#>>
@>
,<@
,?
,?|
,?&
,||
,-
,#-
,@?
,@@
EXISTS
[NOT] IN
ANY
,SOME
,ALL
EXTRACT(... FROM ...)
AT TIME ZONE
:=
syntax for named function arguments.The text was updated successfully, but these errors were encountered: