FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.23k stars 212 forks source link

REPLACE new optional parameter: occurrence #7791

Open EPluribusUnum opened 11 months ago

EPluribusUnum commented 11 months ago

Hi *!

It would be great to control what to replace. 0 : replace all occurrence 1 : replace 1st occurrence 2 : replace 2nd occurrence etc... negative occurrence : count occurrence backward

livius2 commented 11 months ago

above is slightly releated to: simplify usage of regex for matching, replacing n-th match https://github.com/FirebirdSQL/firebird/issues/4743 Allow in-built replace function to use regular expressions https://github.com/FirebirdSQL/firebird/issues/2921