> With 8.4's analytic capabilities you can do this: > select * from ( > select userid, data - lag(data) over (partition by userid order by data) > diff > from foo) q > where diff is not null; Thank you! That worked perfectly!
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных