Postgres下一个/上一行SQL查询

I have the following table structures in a Postgres 9.1 database but the ideal solution should be DB agnostic if possible:I have the following table structures in a Post