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

Support SPLIT_PART function for Postgres

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.39.0
    • None

    Description

      We can support SPLIT_PART function for Postgres:

        split_part ( string textdelimiter textn integer ) → text

      Splits string at occurrences of delimiter and returns the n'th field (counting from one), or when n is negative, returns the |n|'th-from-last field.

      split_part('abc#def#ghi', '#', 2)   # returns 'def'
      split_part('abc,def,ghi,jkl', ',', -2)     # returns 'ghi'
      

      Attachments

        Issue Links

          Activity

            People

              zhuqi Qi Zhu
              zhuqi Qi Zhu
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: