postgresql if else select query

Question

I am trying to make a query that will compare first first condition was to compare the year now and get the maximum year of view view_delinquency_allquarter then, it will execute the first query else second query

BEGIN
IF 
    select max(ctaxyear) as ctaxyear,
        (select cast ( (SELECT EXTRACT(QUARTER FROM TIMESTAMP 'now()'))  as int ) as yearnow) as yearnow
    from view_delinquency_allquarter 
    where ctaxyear > year_next
THEN
   select * from view_delinquency_allquarter;
ELSE 
   select * from view_delinquency;
END IF;
END

Community · Accepted Answer · 2017-05-23 12:29:41Z

0

There are plenty of answers as well as documentation use declare var and then assignment var := (your query result)

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Aug 26, 2015 at 2:56

Dzmitry Savinkou

5,2102 gold badges28 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgresql if else select query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related