Search Postgresql Archives

Re: Localizing stored functions by replacing placeholders in their body

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





ú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)

You should to use PLpgSQL EXECUTE statement, not SQL statement


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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux