Re: [SQL] finding gaps in temporal data

2011-06-15 Thread Samuel Gendler
On Wed, Jun 15, 2011 at 10:23 AM, Samuel Gendler wrote: > I have a fact table that looks like this: > > dim1_fk bigint, > time_fk bigint, > tstamp timestamp without timezone > value numeric(16,2) > > The tstamp column is completely redundant to a colume in the time_utc > table, but I like to leave

[SQL] finding gaps in temporal data

2011-06-15 Thread Samuel Gendler
I have a fact table that looks like this: dim1_fk bigint, time_fk bigint, tstamp timestamp without timezone value numeric(16,2) The tstamp column is completely redundant to a colume in the time_utc table, but I like to leave it there for convenience when writing ad-hoc queries in psql - it allows