From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Return select statement with sql case statement |
Date: | 2018-07-04 22:03:55 |
Message-ID: | 54d91883-6b0d-a8be-5aa4-d70bd5867c7c@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/04/2018 10:32 AM, hmidi slim wrote:
> Actually, I need the use of case because based on the numberOfPremiumDays
> there are different type of treatment:
> select numberOfPremiumDays
> case when numberOfPremiumDays = date_part('day',
> ('2018-11-05'::timestamp) - ('2018-11-01'::timestamp)) then
> select product_id,
> premium_price,
> period_price
> from product
> where occupation_type_id = 1
> group by product_id, occupation_type_id
> else
> select product_id,
> classic_price,
> period_price
> from product1
> where occupation_type_id = 1
> group by product_id, occupation_type_id
>
Then try:
select product_id,
case when numberOfPremiumDays = date_part('day', ('2018-11-05'::timestamp) -
('2018-11-01'::timestamp)) then
premium_price
else
period_price
end as the_price
from product
where occupation_type_id = 1
order by product_id, occupation_type_id
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2018-07-04 22:08:37 | Re: Return select statement with sql case statement |
Previous Message | Adrian Klaver | 2018-07-04 20:07:40 | Re: Unable to Connect to DB Instance |