Re: Return select statement with sql case statement

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.