Foi mal, nova versão:
select data,mem from
(
SELECT
row_number()
OVER (ORDER BY data ROWS BETWEEN 1 PRECEDING AND 1
FOLLOWING ) as linha,
first_value(mem)
OVER ( ORDER BY data ROWS BETWEEN 1 PRECEDING AND 1
FOLLOWING ) as anterior,*
FROM memo order by data ) as janela
WHERE anterior<>mem
ORDER BY data;
data | mem
---------------------+------
2011-11-21 15:22:00 | 1049
2011-11-21 15:25:00 | 1052
2011-11-21 15:26:00 | 1054
2011-11-21 15:29:00 | 1065
2011-11-21 15:30:00 | 1080
2011-11-21 15:32:00 | 1073
2011-11-21 15:33:00 | 1065
2011-11-21 15:34:00 | 1049
(8 rows)
Bruno E. A. Silva.
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
