Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: 3.0.0
    • Component/s: SQL
    • Labels:
      None

      Description

      Function Return Type Description Example Result
      overlay(string placing string from int[for {{int}}]) text Replace substring overlay('Txxxxas' placing 'hom' from 2 for 4) Thomas

      For example:

      SELECT OVERLAY('abcdef' PLACING '45' FROM 4) AS "abc45f";
      
      SELECT OVERLAY('yabadoo' PLACING 'daba' FROM 5) AS "yabadaba";
      
      SELECT OVERLAY('yabadoo' PLACING 'daba' FROM 5 FOR 0) AS "yabadabadoo";
      
      SELECT OVERLAY('babosa' PLACING 'ubb' FROM 2 FOR 4) AS "bubba";
      

      https://www.postgresql.org/docs/11/functions-string.html

        Attachments

          Activity

            People

            • Assignee:
              beliefer jiaan.geng
              Reporter:
              yumwang Yuming Wang
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: