Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • SQL
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: