What is wrong with this Postgresql query in Python?

Question

q = """DELETE FROM my_table
       WHERE id in ({}) (select id from ({}))""".format(list_of_ids_to_be_deleted)

Not sure how to delete rows from the table when I am given a list of indices to be deleted.

JGH · Accepted Answer · 2019-01-07 19:25:35Z

2

The second part of your query is not needed: just use the provided list.

q = """DELETE FROM my_table
       WHERE id in ({})""".format(list_of_ids_to_be_deleted)

You might have to build a comma-separated input, similar to

q = """DELETE FROM my_table
       WHERE id in ({})""".format(','.join(map(str, list_of_ids_to_be_deleted)))

answered Jan 7, 2019 at 19:20

JGH

18.2k5 gold badges40 silver badges57 bronze badges

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

1 Answer 1