title: How to compare the current row with next and previous row in PostgreSQL?
body: <p>I want to know how to retrieve results in a SQL query doing some logic comparison with the next or previous rows. I'm using PostgreSQL.</p>
  
  <p><strong>Example</strong><br>
  Supposing I have a table in my database with two attributes (ordered position and random numbers), I want to retrieve the odd numbers that are between even numbers. How can I do this?</p>
  
  <p><strong>The real usage</strong><br>
  I want to find words that are between two another words which have the category NAME (and the word is not a name). The ordering is provided by sentence and position.</p>
  
  <p><strong>Edit</strong>
  I want to know if the Window function of PostgreSQL are best solution for this kind of problem than doing queries. I heard about them, but never used.</p>