Re: Funny order for posts in thread

I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.

Posted on 2010-01-13 23:28:48.574018-08 by szabgab in response to 12188

Apparently SQLite kept the order of the lines in the database straight so we have not noticed the lack of ORDER BY on the queries. Now that we moved to PostgreSQL this created the funny ordering.

I put an "ORDER BY id DESC" on the SELECT statement of the query now for displaying threads. This is showing the most recent post at the top. Please check.

I know in the near future I should allow each user to decide how s/he wants to see the posts and even adding a threaded view but in the meantime, should I leave it this way or should I turn it around showing the most recent post at the bottom?

Direct Responses: 12193 | Write a response