From: | "Tim Vadnais" <tvadnais(at)earthlink(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | deleting records is failing |
Date: | 2005-12-08 03:13:18 |
Message-ID: | 004301c5fba5$57406220$6601a8c0@timothygwxu5p68ln |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2005-12-08 03:21:23 | Re: deleting records is failing |
Previous Message | Kathy Lo | 2005-12-08 02:25:07 | Re: Memory Leakage Problem |