Postgres Pro
Downloads
Home   >   mailing lists

Change detection - Mailing list pgsql-sql

From Shaozhong SHI
Subject Change detection
Date
Msg-id CA+i5JwZ+XmOF6P4Lo=UTVUJBSQN4EyQL-fe7t4XTLPB9bwq9aQ@mail.gmail.com
Whole thread Raw
Responses Re: Change detection
AW: Change detection
List pgsql-sql
Tree view
A record shows all staff member worked in different departments.

For instance, Tom was in sales for several years and got promoted to management.   How to detect the time of this change?

Data

Staff_ID    Name   Department            Year
1                Tom    Sales                     1990
2                 Tom      Sales                   1991
3                 Tom      Sales                   1991
4                 Tom      Management         1992
4                 Tom     Management           1992


Regards,

David

pgsql-sql by date:

Previous
From: Ankit Kumar Pandey
Date:
Subject: Re: [QUESTION] Window function with partition by and order by
Next
From: Stöcker, Martin
Date:
Subject: AW: Change detection