X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 247259234ED for ; Thu, 22 May 2003 23:34:09 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 08818-08 for ; Thu, 22 May 2003 23:33:38 -0400 (EDT) Received: from tomts21-srv.bellnexxia.net (tomts21.bellnexxia.net [209.226.175.183]) by developer.postgresql.org (Postfix) with ESMTP id E67F792630A for ; Thu, 22 May 2003 20:41:24 -0400 (EDT) Received: from [192.168.1.200] ([64.231.213.3]) by tomts21-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030523004123.DYRW2574.tomts21-srv.bellnexxia.net@[192.168.1.200]>; Thu, 22 May 2003 20:41:23 -0400 Subject: Re: tablename as attribute in pgplsql From: Rod Taylor To: =?ISO-8859-1?Q?Beno=EEt?= Bournon Cc: pgsql-sql@postgresql.org In-Reply-To: <3ECCF0D1.8030705@adelis.com> References: <3ECCF0D1.8030705@adelis.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-/alrUEMuT7LXnTPg/TIO" Organization: Message-Id: <1053650483.279.13.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 22 May 2003 20:41:24 -0400 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/443 X-Sequence-Number: 13608 --=-/alrUEMuT7LXnTPg/TIO Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > I want to use client table as a variable In plpgsql you can do that by using EXECUTE http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D1&file=3Dplpgs= ql-control-structures.html --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-/alrUEMuT7LXnTPg/TIO Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA+zW4y6DETLow6vwwRAhApAJwIfGodBRf86p8zSbgS0RPUOO5ErACaAl8Y BtVgepdXWncCsezKUwwGLb8= =B1HT -----END PGP SIGNATURE----- --=-/alrUEMuT7LXnTPg/TIO--