| From: | Glenn Schultz <glenn(at)bondlab(dot)io> | 
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org | 
| Subject: | initialize and use variable in query | 
| Date: | 2018-12-29 15:40:34 | 
| Message-ID: | CAE-4=KFP9T+RD4kNfu4jY2SHKJEEsSVsF9wUTFzUm01P1vJigw@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
All,
I need to initialize a variable and then use it in query.  Ultimately this
will part of a recursive CTE but for now I just need to work this out.  I
followed the docs and thought I needed something like this.  But does not
work-maybe I have misunderstood.  Is this possible?
SET max_parallel_workers_per_gather = 8;
SET random_page_cost = 1;
SET enable_partitionwise_aggregate = on;
Do $$
Declare startdate date;
BEGIN
startdate := (select max(fctrdt) from fnmloan);
END $$;
select
fnmloan.loanseqnum
,fnmloan.currrpb
from
fnmloan
join
fnmloan_data
on
fnmloan_data.loanseqnum = fnmloan.loanseqnum
where
fnmloan.fctrdt = (select * from startdate)
limit 10
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ray O'Donnell | 2018-12-29 15:47:39 | Re: initialize and use variable in query | 
| Previous Message | Mitar | 2018-12-29 08:07:22 | Using placeholders when creating a materialized view |