public inbox for [email protected]  

help / color / mirror / Atom feed

From: H <[email protected]>
To: PostgreSQL Users Mailing List <[email protected]>
Subject: Re: Combining metavariables and table names
Date: Mon, 29 Dec 2025 19:58:06 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwb9jdGH6-og4HFQv=AU7UH+V2AjoQy2y+xZ_Cjz1bx5FA@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwb9jdGH6-og4HFQv=AU7UH+V2AjoQy2y+xZ_Cjz1bx5FA@mail.gmail.com>

On December 28, 2025 8:53:50 PM EST, "David G. Johnston" <[email protected]> wrote:
>On Sunday, December 28, 2025, H <[email protected]> wrote:
>
>>
>> I have a feeling I might be missing how to use the combination of a
>> metavariable and a table name when used in an argument to a
>procedure.
>
>
>No, what you are doing is impossible if you limit yourself to direct
>SQL
>command syntax writing.
>
>
>> Even though I gotten it to work, what would the correct usage be?
>>
>
>I’d probably do something like:
>
>versioning(…, format(‘%I.%I’, :’s’, ‘test_history’), …)
>
>David J.

Just tried your suggestion to use format() but it resulted in a 'syntax error at or near "("'

Seems I am stuck using the approach I found to work, ie. generating a string constant in another meta variable.

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Combining metavariables and table names
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox