From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | help deleting obsolete records |
Date: | 2002-10-15 19:28:39 |
Message-ID: | 5.1.1.6.0.20021015145821.02d52070@pop6.sympatico.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I don't know how to write an SQL for the following:
Table "teamwork"
Attribute | Type | Modifier
-----------+----------------------+-------------
team | character varying(8) | not null
emp | character varying(2) | not null
Table "timesheet"
Attribute | Type | Modifier
-----------+--------------------------+-------------
emp | character varying(8) | not null
team | character varying(2) | not null
lo_shift | timestamp with time zone |
hi_shift | timestamp with time zone |
Consider a subset of data from timesheet which meets the condition:
lo_shift > (now()-'30days'::interval)
Now I want to delete all rows from teamwork where the data pair "emp,team"
is *not* in the subset of data retrieved from timesheet. It is possible
that timesheet will contain multiple rows for any given emp,team pair.
Frank
From | Date | Subject | |
---|---|---|---|
Next Message | Thad Humphries | 2002-10-15 20:59:29 | where are the error codes? |
Previous Message | Thad Humphries | 2002-10-15 16:44:14 | ECPG fails to handle hex constants |