Report question

Question: How can I select adjacent rows to an arbitrary row (in sql or postgresql)?