X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1DD7B474E53 for ; Sun, 23 Feb 2003 19:26:21 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 49042-09 for ; Sun, 23 Feb 2003 19:26:10 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 5EC274758DC for ; Sun, 23 Feb 2003 19:26:10 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2854003; Sun, 23 Feb 2003 16:26:12 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "James Cooper" Subject: Re: syntax question Date: Sun, 23 Feb 2003 16:25:26 -0800 User-Agent: KMail/1.4.3 References: <006401c2db87$fc09be00$c900a8c0@jax> <200302231507.23831.josh@agliodbs.com> <009a01c2db95$15173e10$c900a8c0@jax> In-Reply-To: <009a01c2db95$15173e10$c900a8c0@jax> Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Message-Id: <200302231625.26793.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/522 X-Sequence-Number: 11920 James, > but thats what: > rec record > select into rec id from table; > return rec.id > > does > > my question was can i do this with a query built inside a string? No. That's what I was talking about. You have to use the loop. --=20 Josh Berkus Aglio Database Solutions San Francisco