Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6308

Add PostgreSQL functions up to PostgreSQL v14

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • core
    • None

    Description

      Support the following PostgreSQL functions for parity with PostgreSQL 14:

      • REGEXP_LIKE
        • The Spark version of this is being implemented in CALCITE-6278
        • The PostgreSQL version requires supporting a 3-arg version that takes in flags.
      • REGEXP_REPLACE
        • There is an existing implementation.
        • PostgreSQL requires supporting an optional extra flags argument
      • DATE_PART
        • PostgreSQL and Redshift let the date_part parameter be a string instead of a just an enum-like identifier (eg DATE_PART('year', ...) and DATE_PART(year, ...) are both supported.
        • SQL Server does not support using a string here.
      • LOG
        • We have the BigQuery implementation which has a 1-arg overload that uses base e (ln), and a 2-arg overload which is LOG(value, base)
        • PostgreSQL's 1-arg version uses base 10 and the 2-arg overload has the order reversed – LOG(base, value)
      • POW
        • Our existing implementation always returns double.
        • PostgreSQL allows returning a numeric instead of a double when inputs are numeric. Not sure if this makes sense though.
      • RANDOM
        • This is an alias for RAND(), except it should not support passing in a seed.
      • TO_CHAR
      • TO_DATE
      • TO_TIMESTAMP
        • PostgreSQL supports different format strings than the version we have implemented.

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            jduong James Duong
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: