stina:
> I See.
>
> And the analysis you need to do, the sum of the rows with the same
> keys (until they change) will have to be done over all
> table?
> Or just over some predefined interval ?
>
> Best,
> Oliveiros
> - Original Message - From
> It seems to me that it might be possible, I'm just affraid that the query
> would become too complex and thus slow...
>
> Best,
> Oliveiros
>
> - Original Message - From: "Rainer Stengele"
>
> To: "Oliveiros d'Azevedo Cristina"
> Or is it possible to have the same combination on one day with several sets?
>
> Best,
> Oliveiros
>
>
> - Original Message - From: "Rainer Stengele"
>
> Newsgroups: gmane.comp.db.postgresql.sql
> To: "Oliveiros d'Azevedo Cristina&quo
Howdy Cristina,
unfortunately things are more complicated. I have inserted an excerpt of the
real data here:
TableID MasterID dtBegin dtEnd
idR id
.
Hope I could express it!
Mit freundlichen Grüßen / Best Regards
Rainer Stengele
__|___
| Dipl. Inf. (Univ.) Rainer Stengele
| Technical Control - System Administration
|
| email: rainer.steng...@diplan.de
| voice/fax: ++49-9131-7778-85/88
| WWW : http://www.diplan.de
Hi,
having a table similar to
| 1 | B | [2010-07-15 Do] |
| 1 | B | [2010-07-16 Fr] |
|---+---+-|
| 2 | C | [2010-07-17 Sa] |
| 2 | C | [2010-07-18 So] |
|---+---+-|
| 1 | B | [2010-07-19 Mo] |
| 1 | B | [2010-07-20 Di] |
| 1 | B | [2010-07-21 Mi] |
| 1 | B | [2010
