edificio | sala | idPeriodo | var | disciplina | turno | parte | max | tipo | duracao | to_char ----------+-------+-----------+-----+------------+-------+-------+-----+------+---------+--------- A | 5 | 136 | EA | ALGA | 1 | A | 0 | TP | 01:30 | 16:30 CP | 3.13 | 136 | EA | ALGA | 1 | A | 0 | TP | 01:30 | 16:30 CP | 3.7 | 136 | EA | ALGA | 1 | A | 0 | TP | 01:30 | 16:30 CP | Anf.B | 136 | EA | ALGA | 1 | A | 0 | TP | 01:30 | 16:30 J | 16 | 136 | EA | ALGA | 1 | A | 0 | TP | 01:30 | 16:30 J | 17 | 136 | EA | ALGA | 1 | A | 0 | TP | 01:30 | 16:30 J | 5 | 136 | EA | ALGA | 1 | A | 0 | TP | 01:30 | 16:30 CP | 3.13 | 136 | EA | ALGA | 1 | B | 0 | TP | 01:30 | 17:30 CP | 3.18 | 136 | EA | ALGA | 1 | B | 0 | TP | 01:30 | 17:30 CP | 3.21 | 136 | EA | ALGA | 1 | B | 0 | TP | 01:30 | 17:30 CP | 3.5 | 136 | EA | ALGA | 1 | B | 0 | TP | 01:30 | 17:30 J | 16 | 136 | EA | ALGA | 1 | B | 0 | TP | 01:30 | 17:30 J | 17 | 136 | EA | ALGA | 1 | B | 0 | TP | 01:30 | 17:30 J | 5 | 136 | EA | ALGA | 1 | B | 0 | TP | 01:30 | 17:30 A | 5 | 136 | EA | ALGA | 2 | A | 1 | TP | 01:30 | 13:30 # new 1 A | 5 | 136 | EA | ALGA | 2 | A | 0 | TP | 01:30 | 15:00 # old 1 CP | 3.13 | 136 | EA | ALGA | 2 | A | 1 | TP | 01:30 | 13:30 # new 2 CP | 3.13 | 136 | EA | ALGA | 2 | A | 0 | TP | 01:30 | 15:00 # old 2 CP | 3.7 | 136 | EA | ALGA | 2 | A | 1 | TP | 01:30 | 13:30 # new 3 CP | 3.7 | 136 | EA | ALGA | 2 | A | 0 | TP | 01:30 | 15:00 # old 3 CP | Anf.B | 136 | EA | ALGA | 2 | A | 1 | TP | 01:30 | 13:30 (...) CP | Anf.B | 136 | EA | ALGA | 2 | A | 0 | TP | 01:30 | 15:00 J | 16 | 136 | EA | ALGA | 2 | A | 1 | TP | 01:30 | 13:30 J | 16 | 136 | EA | ALGA | 2 | A | 0 | TP | 01:30 | 15:00 J | 17 | 136 | EA | ALGA | 2 | A | 1 | TP | 01:30 | 13:30 J | 17 | 136 | EA | ALGA | 2 | A | 0 | TP | 01:30 | 15:00 J | 5 | 136 | EA | ALGA | 2 | A | 1 | TP | 01:30 | 13:30 J | 5 | 136 | EA | ALGA | 2 | A | 0 | TP | 01:30 | 15:00 CP | 3.13 | 136 | EA | ALGA | 2 | B | 0 | TP | 01:30 | 17:00 CP | 3.13 | 136 | EA | ALGA | 2 | B | 1 | TP | 01:30 | 18:00 CP | 3.18 | 136 | EA | ALGA | 2 | B | 0 | TP | 01:30 | 17:00 CP | 3.18 | 136 | EA | ALGA | 2 | B | 1 | TP | 01:30 | 18:00 CP | 3.21 | 136 | EA | ALGA | 2 | B | 0 | TP | 01:30 | 17:00 CP | 3.21 | 136 | EA | ALGA | 2 | B | 1 | TP | 01:30 | 18:00 CP | 3.5 | 136 | EA | ALGA | 2 | B | 0 | TP | 01:30 | 17:00 CP | 3.5 | 136 | EA | ALGA | 2 | B | 1 | TP | 01:30 | 18:00 J | 16 | 136 | EA | ALGA | 2 | B | 0 | TP | 01:30 | 17:00 J | 16 | 136 | EA | ALGA | 2 | B | 1 | TP | 01:30 | 18:00 J | 17 | 136 | EA | ALGA | 2 | B | 0 | TP | 01:30 | 17:00 J | 17 | 136 | EA | ALGA | 2 | B | 1 | TP | 01:30 | 18:00 J | 5 | 136 | EA | ALGA | 2 | B | 0 | TP | 01:30 | 17:00 J | 5 | 136 | EA | ALGA | 2 | B | 1 | TP | 01:30 | 18:00 (42 rows)