Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vaO3z-007j1u-2N for pgsql-general@arkaria.postgresql.org; Tue, 30 Dec 2025 00:58:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vaO3y-001J1P-1W for pgsql-general@arkaria.postgresql.org; Tue, 30 Dec 2025 00:58:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vaO3y-001J1H-0H for pgsql-general@lists.postgresql.org; Tue, 30 Dec 2025 00:58:14 +0000 Received: from mout.perfora.net ([74.208.4.197]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vaO3w-003GAp-2i for pgsql-general@lists.postgresql.org; Tue, 30 Dec 2025 00:58:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=meddatainc.com; s=s1-ionos; t=1767056290; x=1767661090; i=agents@meddatainc.com; bh=5IWz6G+dNAWRABTiyySiKh2J8xlhVoKS/l9g8ddROPM=; h=X-UI-Sender-Class:Date:In-Reply-To:References:MIME-Version: Content-Type:Content-Transfer-Encoding:Subject:To:From:Message-ID: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=rY18dLmpLUdL8svEE/ijIWWC95sHTPSvFQKWB4uAxt3GWPwr9w3b2MSMkGYArGsL FCE6n9pgUKWFAmvsp6hWny8mTQ+OU+u4VhJa+gi8kHt2n0QQ5bkt9P1VZexBIzdy/ 2ZdI6xAAbxIhvnFKBXsLsMQHTnsbCQSV7b89BNH6zkonCyLBK6uXWroZRf9URi1W3 35sUEmRfY8BVBx6FRTI1MdzHbFgGoMdNHEAy8Ugam1Rt/gpXQf/L7ndi5fGBFFD6z u6GOg86Tu1BFXVtnhBoh2mVFFme6sCgkvMFL+dvV7Gw3ZpoDHqCmXf76X0YOPHp9o Vn0NnnVlFlVRWkRyOw== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from [10.120.190.106] ([166.170.34.239]) by mrelay.perfora.net (mreueus004 [74.208.5.2]) with ESMTPSA (Nemesis) id 1MvJPR-1vruqZ1rGL-00rq7E for ; Tue, 30 Dec 2025 01:58:10 +0100 Date: Mon, 29 Dec 2025 19:58:06 -0500 User-Agent: K-9 Mail for Android In-Reply-To: References: <8254F175-871C-4678-8D28-A67E09B099A6@meddatainc.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Subject: Re: Combining metavariables and table names To: PostgreSQL Users Mailing List From: H Message-ID: X-Provags-ID: V03:K1:1uBAkv6wXPiSJ4fTLmepk5ad4pxfzwEsbEWiicmUif1Sa3ftTGf iUTigd4h/i2iwK4jhkyOfSBU5WMuoL0hv9EahSp6m93zijie+f9RuI5MCFLHlqpKUkkX9CQ 6AFNHNJ8U9zfIM+F9DzkiHdWSkeXZtlyqBnU7uzsZdQ73UDTxV5lA7SMrkpjVObnnLwpC7x 4zA3uM9JJ2UA4FIv/Kijw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:lOk3ugEytug=;6/E3D9pYRBwi+j/UkLJL48cYtrY 9ZAGlnIy5QSsi39fUavSWZfHOxh9BF6jNN/DGTVH/bPNrpkvCBILAaGGSZpGaRkFyuaZMl4+s Wptq/b0iZxuujHD5YR0VO5U7kJQbC5ljtoZeoROojPbX/dSBIYwSj9I+1xLiumNzJD7Hy3Auh sVB8AymjuJVUAU0L3NTrOZALTG+qDlO19UM5yDWU4AMacqaXcJ5SGALkTxabxFJQ/sE9JeNL2 AgJF0m6MK4j2+A3dfQo5HqhkwUIcl9nlsplZaQ6oSxcJuhmkNN2HHm42S3FqLt+/Oqv53nkfs HDzkJkbbso06Y2vEI2n8T/yxewxChozP9eZ1xNkHzm62amSUn6hvH1eERFpfGYQOxbRfGUp8a rqgJVRm55qTGKHYGsmRWAxhl6hRMKr+Qlk12SEjkBFlV+yjT+ky1LBXvs3hKI1e4Fawb28jld nytByrGH3YLi4CDBpWsyYxifc39M9ljTO/hacFziUrvQREqje9+c5/iiSjv4AqKufvTXDbZJn yWDve3L+aHzKXnhnUF572kCU6Y7A1LOJ9dmaSyveTo+i9p0kmPkSbypMKa/WPNszkWk6hf30u IhKCo0kUQ85PqoAL1V+jWMYlqRY665cFkl/NivKfPrCGlj4fI32o+Cij6CvdpwFjVBGe7FEbv a2zmPd5+05CLDVxchI5QKp7x4iA/JRtAQApmWCmd/KHWSWfLlLtXl1egOc2wdCbiyFZduMcvZ 9HCVhZNAE7nxkmEfNkZjhk1Bpp9khSQrLTdiWvb32eJVMcEePg/+gZhdvRO7ndlgyJv3lOm5G TO05ywAaU8H32sM8oabaAthxmV6tsapTXlB4YKQRBS0LC3Hiet1lVGCWn8FJaY+zwbsFqeMbB clrvQXBZynIKdkybs/DTN5ohBrBIG7OeGwTpDxZ8BhXgaFdaVOW360+QexL+7qGUhz8CUH4Da BiipFqbvVlFdDGd4yV+wrj5xe0W85ZFa5AESZmDhZj+LKFssVssY6yd1QydRZG5kRX7WIieEQ l8NmBcI3FXd7wRDKVtcRR6n4wa4BR8rZC7Tx+VAe2ipuVJGDTNB1S02Bs2UovZeq0t/DE96zP L0BG/qJUC7yJ9yEGDhz51cwX4IbCSh9cdw2cedoJ9OOMIq/lqOOzobuskG9JnIUt/7hntTER/ CXQTPl9nJvyfrgHVeXUJsAuDCSeseyCEewo/zZF8Q91qzYu0jiVN4SxT0o2P2zn++/81H4Xak Fsc7c1T8HyhITLePiu+QPx3bYul2q1L4UBBkmNflubP7mue7LdyHNcxuma+mBRbaaxvU2EEJ8 5Ob9/uqZgRlz/YsJ/fpOStJntnKmDKvnHPYN5bHQzPhFRaoJJjPkhr9xYekXswE/nownr3iQT NSFc2GqeBg2cV2NReiCXucdjEXaXI8YeFqIkpjXOZ0mAs1bLC/aLn4i4ikXsntRrEcJgq4Eu/ 0HcFFt786ejfhqYtXUT3GkjWC51Nm1GJUD7c1bQJnkmPV72qSJig12STN3mnKGt+L4lxleHWt 7FFYGArrrskY/I4gzOq2Uf5NHQ33FaJ1med+ZdYv7lzCmluexllHpI3ZUfVSWQk8k16Cx01+W FDhQUPR1ldK94suA1cxR4v/pDFQPMaXR1s4SFZED/qjQvBJhTwMmg/ta7oB02zqLxTtmPBcri 4DANgFScwgzO1FTr3LJ5PPQffILjPj92RBuzeWOzqnhxdSdfzAnNToFC0Gfsz2dtGIGniDv/2 2GivtDdDk86jE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On December 28, 2025 8:53:50 PM EST, "David G=2E Johnston" wrote: >On Sunday, December 28, 2025, H 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=2E > > >No, what you are doing is impossible if you limit yourself to direct >SQL >command syntax writing=2E > > >> 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=2E%I=E2=80=99, :=E2=80=99s=E2=80= =99, =E2=80=98test_history=E2=80=99), =E2=80=A6) > >David J=2E Just tried your suggestion to use format() but it resulted in a 'syntax er= ror at or near "("' Seems I am stuck using the approach I found to work, ie=2E generating a st= ring constant in another meta variable=2E