Home > mailing lists

query variables - Mailing list pgsql-general

From	j0rd1 adame
Subject	query variables
Date	January 28, 2005 04:27:16
Msg-id	200501271929.26847.jordi@jordi.net Whole thread Raw
Responses	Re: query variables
List	pgsql-general

Tree view

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

Attachment

msg-32091-91837.dat

pgsql-general by date:

From: "DBTools Software"
Date: 28 January 2005, 04:25:17
Subject: Re: convert mdb files to pg?

From: "Jonel Rienton"
Date: 28 January 2005, 04:35:15
Subject: Re: changing sort_mem on the fly?

query variables - Mailing list pgsql-general

Attachment

Previous

Next