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
Дата:
От: Michael Glaesemann
Дата:
FAQ