| 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: | Whole Thread | Raw Message | 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 |