query variables

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/