I am trying to insert into table with multiple queries. And its not working, here is my work.
insert into post_topics_ta (id,post_id,topic_id,confidence_score) SELECT * FROM post_topics WHERE post_id in (SELECT id FROM posts WHERE date_posted::date BETWEEN '2019-12-30' and '2020-01-26')
But this is not inserting any values into the target table. Could anyone please let me know how to achieve this?
Thanks in advance!!!