declaring variables?

[Andy Kriger]

Is it possible to do something like this in postgres?

set variable_name = select ....
select count(*)/$variable_name ....

Basically, for a series of queries I need to do, I want to pull a count once
and reuse that count in subsequent queries to calculate percentages.

thx
andy

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Jonathan Bartlett]

You can create a temporary table to do this. Temporary tables are only
valid in the session they are created in. So,

create temporary table mytmptable(myvar whatevertype);

set variable_name = select ....
insert into mytmptable (myvar) select ....
select count(*)/$variable_name ....

select count(*) / (select myvar from mytmptable limit 1) ....

Jon
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[CoL]

Hi,

Jonathan Bartlett wrote, On 7/2/2003 9:39 PM:

You can create a temporary table to do this. Temporary tables are only
valid in the session they are created in. So,

create temporary table mytmptable(myvar whatevertype);

set variable_name = select ....

insert into mytmptable (myvar) select ....

select count(*)/$variable_name ....

select count(*) / (select myvar from mytmptable limit 1) ....

How about:
select count(*) / (select 12) from ... ?:))

C.