Conditional insert statement in postgresql

Question

I am trying to run a conditional insert statement but running to issues. Here the statement:

insert into category_content (category_id, content_id, content_type_id, priority) (select 29, id, 1, 1 from article where blog_id = 80) 
where not exists(
select * from category_content where category_id = 29 and firstname in (select id from article where blog_id = 80)
);

This is the error I get:

ERROR:  syntax error at or near "where"
LINE 2: where not exists(
        ^
********** Error **********

ERROR: syntax error at or near "where"
SQL state: 42601
Character: 153

Looks like you are missing "FROM" in the main part of your query. — rd_nielsen
– rd_nielsen, Commented Jun 15, 2017 at 21:26

score 6 · Accepted Answer · 2017-06-16 05:35:21Z

6

You can't have two where clauses, only one:

insert into category_content (category_id, content_id, content_type_id, priority) 
select 29, id, 1, 1 
from article 
where blog_id = 80
  and not exists(select * 
                 from category_content 
                 where category_id = 29 
                   and content_id in (select id 
                                      from article 
                                      where blog_id = 80));

Collectives™ on Stack Overflow

Conditional insert statement in postgresql

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