Postgres Pro
Downloads
Home   >   mailing lists

Re: Implementing SCD Type 2. - Mailing list pgsql-novice

From Kevin Grittner
Subject Re: Implementing SCD Type 2.
Date
Msg-id 1364941567.74815.YahooMailNeo@web162904.mail.bf1.yahoo.com
Whole thread Raw
In response to Implementing SCD Type 2.  (Henrik Aagaard Sørensen<henrikaagaardsorensen@gmail.com>)
List pgsql-novice
Tree view 
Henrik Aagaard Sørensen <henrikaagaardsorensen@gmail.com> wrote:

> I'm looking into implementing SCD Type 2 in PostgreSQL:
> http://en.wikipedia.org/wiki/Slowly_changing_dimension
>
> with the approach of having valid_from and valid_to fields in a table.

You might be interested in this recent thread:

http://www.postgresql.org/message-id/flat/50D99278.3030704@dc.baikal.ru#50D99278.3030704@dc.baikal.ru

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-novice by date:

Previous
From: Thangalin
Date:
Subject: Re: Cannot create perlplu function
Next
From: JORGE MALDONADO
Date:
Subject: 32 and 64-bit versions of PostgreSQL for Windows