From: James Cooper <jim@luckydigital.com>
To: sql <pgsql-sql@postgresql.org>
Subject: syntax question
Date: Mon, 24 Feb 2003 11:07:41 +1300
Message-ID: <006401c2db87$fc09be00$c900a8c0@jax> (raw)
FOR total IN EXECUTE subquery LOOP
END LOOP;
RETURN total.tot;
I have a function that returns a total from a dynamic query I use to generate the total query
I've tried to modify it as a loop to get a single row value is unnecessary but I'm failing on my syntax
I've tried
select into total subquery
-but it wont work(when I attempt this I remove the select from the beginning of my sub query)
can someone show me the syntax to execute a select into with a string that contains a query in it?
James
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: pgsql-sql@postgresql.org
Cc: jim@luckydigital.com
Subject: Re: syntax question
In-Reply-To: <006401c2db87$fc09be00$c900a8c0@jax>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox