how to execute multiple statement in PostgreSQL

Asked Jun 01 '18 at 09:41

Active Jun 01 '18 at 10:01

Viewed 656 times

I have a query like below:

if extract(dow from current_date)=1 then
select * form dev
else
select * from dev1
end if

Error:

ERROR: syntax error at or near "if" LINE 1: if extract(dow from current_date)=1 then

How can I perform ddl and dml operation in single execution?

edited Jun 01 '18 at 10:01

Ralf Stubner

asked Jun 01 '18 at 09:41

Suresh Alathuru

There is no `IF` in SQL. Try rewriting it into one or two `WHERE` clauses. – joop Jun 01 '18 at 09:44
1

You seem to think SQL is a programming language. Maybe have a look at PL/pgSQL: https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html – moooeeeep Jun 01 '18 at 09:46
Related: https://stackoverflow.com/q/11299037/1025391 – moooeeeep Jun 01 '18 at 09:49
This seems like a rather strange request and might indicate a badly designed data model. – a_horse_with_no_name Jun 01 '18 at 10:02
Use conditional expression provided by postgres: https://www.postgresql.org/docs/7.4/static/functions-conditional.html – user5542464 Jun 01 '18 at 11:05

0 Answers0