Postgresql - execute only certain IF statements

Question

I would like to put toghether the reslt of some queries by using UNION. But I want to execute only some of the queries... in the sample below the part ('Daily','Yearly') will be filled in automatically.

something along the lines of:

(if 'Daily' in ('Daily','Yearly') then
my first query goes here...
end if)
UNION ALL
(if 'Monthly' in ('Daily','Yearly') then
my second query goes here...
end if)
UNION ALL
(if 'Yearly' in ('Daily','Yearly') then
my third query goes here...
end if)

In this sample, the result of the second query should not be present in the output.

on a side note: I do already have the 3 working queries, what i am missing is how to execute them dynamically and put them toghether to a single output.

Anton Grig · Accepted Answer · 2021-11-10 12:53:14Z

4

Try to put these conditions in the appropriate "Where" sections. Engine have to skip queries if the literal conditions are not met.

my first query goes here...
Where 'Daily' in ('Daily','Yearly')
UNION ALL
my second query goes here...
Where 'Monthly' in ('Daily','Yearly')
UNION ALL
my third query goes here...
Where 'Yearly' in ('Daily','Yearly')

answered Nov 10, 2021 at 12:53

Anton Grig

1,71910 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Postgresql - execute only certain IF statements

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related