with table1 as (select * from table2) delete * from table1;
with table1 as (select * from table2) delete * from table1 where col1 = 'something';
Both of the above query are returning error after execution? Can someone help me here?
Read more here: https://stackoverflow.com/questions/64401650/how-to-use-delete-clause-after-with-clause-in-postgresql
This content was originally published by Rahul Kumar at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.