filtering based on table of start/end times

Поиск
Список
Период
Сортировка
От Seb
Тема filtering based on table of start/end times
Дата
Msg-id 8761eqbwip.fsf@net82.ceos.umanitoba.ca
обсуждение исходный текст
Ответы Re: filtering based on table of start/end times  (Bryan L Nuse <nuse@uga.edu>)
Re: filtering based on table of start/end times  (Tim Schumacher <tim@bandenkrieg.hacked.jp>)
Re: filtering based on table of start/end times  (Tim <tim@datenknoten.me>)
Список pgsql-sql
Hi,

At first glance, this seemed simple to implement, but this is giving me
a bit of a headache.

Say we have a table as follows:

CREATE TABLE voltage_series
( voltage_record_id integer NOT NULL DEFAULT nextval('voltage_series_logger_record_id_seq'::regclass), "time" timestamp
withouttime zone NOT NULL, voltage numeric, CONSTRAINT voltage_series_pkey PRIMARY KEY (voltage_record_id));
 

So it contains a time series of voltage measurements.  Now suppose we
have another table of start/end times that we'd like to use to filter
out (or keep) records in voltage_series:

CREATE TABLE voltage_log
( record_id integer NOT NULL DEFAULT nextval('voltage_log_record_id_seq'::regclass), time_beg timestamp without time
zoneNOT NULL, time_end timestamp without time zone NOT NULL, CONSTRAINT voltage_log_pkey PRIMARY KEY (record_id));
 

where each record represents start/end times where the voltage
measurement should be removed/kept.  The goal is to retrieve the records
in voltage_series that are not included in any of the periods defined by
the start/end times in voltage_log.

I've looked at the OVERLAPS operator, but it's not evident to me whether
that is the best approach.  Any tips would be appreciated.

Cheers,

-- 
Seb




В списке pgsql-sql по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Bug or feature in AFTER INSERT trigger?
Следующее
От: Bryan L Nuse
Дата:
Сообщение: Re: filtering based on table of start/end times