Supported Character Types

May 23, 2018 ยท View on GitHub

Text

Types

  • text

Functions

  • Relational operators: !=, <>, =, <=, <, >, >=

    • BETWEEN x AND y
    • NOT BETWEEN x AND y
    • BETWEEN SYMMETRIC x AND y
    • NOT BETWEEN SYMMETRIC x AND y
    • IS DISTINCT FROM b
    • IS NOT DISTINCT FROM b
    • expression IS NULL
    • expression IS NOT NULL
    • expression ISNULL
    • expression NOTNULL

  • Mathematical Operators: +, -, *, /, %

  • String functions: ||, LIKE, SUBSTRING