Re: Localizing stored functions by replacing placeholders in their body

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Localizing stored functions by replacing placeholders in their body
Date: 2021-03-02 17:04:34
Message-ID: CAADeyWgx5bEw2xu5DveHH8K6xtvm+voPJuP1gQF+6jdYH=TJDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ah, I understand, that was the wrong EXECUTE, thank you.

Another idea: can't I use \set command for my purpose of localizing stored
functions?

\set my_func_declaration `sed 's/this/that/' my_func.sql`

But how to execute the declaration? I can only echo it with

select (:'my_func_declaration');

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2021-03-02 17:30:23 Re: Localizing stored functions by replacing placeholders in their body
Previous Message Pavel Stehule 2021-03-02 17:00:30 Re: Localizing stored functions by replacing placeholders in their body