On Mon, 2010-04-05 at 18:28 +0200, Gerhard Heift wrote:
> create type period as (
> since timestamptz,
> "until" timestamptz
> );
Please take a look at:
http://pgfoundry.org/projects/temporal
That may be a more useful type for you, and it's also called "PERIOD".
> with rows:
> + a gist inde
Hello,
I have person to group mapping in which I want to store the time, when this
mapping is valid. I can store the valid time in an array or in seperate rows.
in rows:
create table group_mapping (
group name not null,
person integer not null,
valid_since timestamptz not null,
valid_unt
