Re: [GENERAL] deleting records is failing

2005-12-07 Thread Michael Glaesemann
On Dec 8, 2005, at 13:01 , Tim Vadnais wrote: Thank you. I've modified the code to read: DELETE from tracker WHERE tracker.episode_id = 277 AND tracker.date_of_service BETWEEN '09/12/2005'::date - interval '1 day' AND '10/20/2005'::date + interval '1 day' If you're going to be doing a lo

Re: [GENERAL] deleting records is failing

2005-12-07 Thread Tim Vadnais
ge- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Glaesemann Sent: Wednesday, December 07, 2005 7:21 PM To: Tim Vadnais Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] deleting records is failing On Dec 8, 2005, at 12:13 , Tim Vadnais wrote: > I have a set

Re: [GENERAL] deleting records is failing

2005-12-07 Thread Michael Glaesemann
On Dec 8, 2005, at 12:13 , Tim Vadnais wrote: 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 an

[GENERAL] deleting records is failing

2005-12-07 Thread Tim Vadnais
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