deleting records is failing
От
Tim Vadnais
Тема
deleting records is failing
Дата
Msg-id
004301c5fba5$57406220$6601a8c0@timothygwxu5p68ln
Список
Дерево обсуждения
deleting records is failing "Tim Vadnais" <tvadnais@earthlink.net>
Re: deleting records is failing Michael Glaesemann <grzm@myrealbox.com>
Re: deleting records is failing "Tim Vadnais" <tvadnais@earthlink.net>
Re: deleting records is failing Michael Glaesemann <grzm@myrealbox.com>
This question is probably real easy to answer, but I've got myself into a vicious loop and can't see the forest through the trees. I have a set of records spanning several dates, and I want to delete some records within a specific date range. For example, I have a record for each day from Sept 1 through Nov 1, and I want to delete the records for Sept 21 through 10/20 and leave all the rest. Here is my query that's deleting all the records for the episode DELETE FROM tracker WHERE tracker.episode_id = 238 AND ( rug_tracker.date_of_service < '09/12/2005' OR rug_tracker.date_of_service > '10/20/2005' ); I would really appreciate someone showing me the way through the forest. Thank you, Tim
В списке pgsql-general по дате отправления
От: Ciclo de Cursos Diciembre 2005-Enero 2006
Дата: