deleting records is failing

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

Responses

Browse pgsql-general by date

  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