title: Selecting from view changes order of rows compared to selecting from view's script
body: <p>I made a view in PostgreSQL and I've run into an issue when selecting from a certain view.
  The order of the rows has a lot of meaning, and when I select using the view the order is changed compared to when I'm just running the script myself.</p>
  <p>PS: I join a few tables using a column that determines the order of the rows.
  Meaning I select table1.order_index and join another table on that table's order_index column.</p>
  <p>What's the explanation for something like that?
  Thanks.</p>