MIME-Version: 1.0
In-Reply-To: <8254F175-871C-4678-8D28-A67E09B099A6@meddatainc.com>
References: <8254F175-871C-4678-8D28-A67E09B099A6@meddatainc.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 28 Dec 2025 18:53:50 -0700
Message-ID: <CAKFQuwb9jdGH6-og4HFQv=AU7UH+V2AjoQy2y+xZ_Cjz1bx5FA@mail.gmail.com>
Subject: Re: Combining metavariables and table names
To: H <agents@meddatainc.com>
Cc: PostgreSQL Users Mailing List <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000cbb39306470d83c9"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwb9jdGH6-og4HFQv%3DAU7UH%2BV2AjoQy2y%2BxZ_Cjz1bx5FA%40mail.gmail.com>
Precedence: bulk

--000000000000cbb39306470d83c9
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sunday, December 28, 2025, H <agents@meddatainc.com> 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=E2=80=99d probably do something like:

versioning(=E2=80=A6, format(=E2=80=98%I.%I=E2=80=99, :=E2=80=99s=E2=80=99,=
 =E2=80=98test_history=E2=80=99), =E2=80=A6)

David J.

--000000000000cbb39306470d83c9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sunday, December 28, 2025, H &lt;<a href=3D"mailto:agents@meddatainc.com=
">agents@meddatainc.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote"=
 style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><b=
r>
I have a feeling I might be missing how to use the combination of a metavar=
iable and a table name when used in an argument to a procedure.</blockquote=
><div><br></div><div>No, what you are doing is impossible if you limit your=
self to direct SQL command syntax writing.</div><div>=C2=A0</div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc sol=
id;padding-left:1ex">
Even though I gotten it to work, what would the correct usage be?<br>
</blockquote><div><br></div><div>I=E2=80=99d probably do something like:</d=
iv><div><br></div><div>versioning(=E2=80=A6, format(=E2=80=98%I.%I=E2=80=99=
, :=E2=80=99s=E2=80=99, =E2=80=98test_history=E2=80=99), =E2=80=A6)</div><d=
iv><br></div><div>David J.</div><div><br></div>

--000000000000cbb39306470d83c9--