> 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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
