Thread: query variables

Hi:
Is there any way to save the result of a query in a variable, so that i could
use that value in another query??

something like set VARIABLENAME = select count(1) from table;
and then
select 56778/VARIABLENAME as final_result;

thanks
--
Jordi Adame V
jordi (.a.) jordi.net
http://www.lawaloca.com

On Thu, Jan 27, 2005 at 07:29:24PM -0600, j0rd1 adame wrote:

> Is there any way to save the result of a query in a variable, so that i could
> use that value in another query??
>
> something like set VARIABLENAME = select count(1) from table;
> and then
> select 56778/VARIABLENAME as final_result;

You could do it in a PL/pgSQL function or a function written in
another procedural language.  Another way would be to use a temporary
table:

CREATE TEMPORARY TABLE tmp AS SELECT count(*) AS foocount FROM foo;
SELECT 56778 / (SELECT foocount FROM tmp) AS final_result;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/