út 2. 3. 2021 v 17:55 odesílatel Alexander Farber <alexander.farber@xxxxxxxxx> napsal:
Thank you for the \! hint, Pavel, didn't know about that!Is it possible to have a pure SQL solution? (To avoid having to install "sed" on my Win 10 PC)
But I don't know - all this is server side, and you do some things on client side
Maybe by using EXECUTE?EXECUTE REGEXP_REPLACE($localize$CREATE OR REPLACE FUNCTION my_func()RETURNS text AS$func$SELECT '$(placeholder)';$func$ LANGUAGE sql IMMUTABLE;$localize$, '\$\(\w+\)', 'English word', 'g');
Unfortunately, I get the error:ERROR: prepared statement "regexp_replace" does not exist