Pat Maddox wrote:
On 10/26/07, brian <brian@xxxxxxxxxxxxxxxx> wrote:SELECT * FROM posts ORDER BY root_id, id; brian ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/Okay, but what if I want to order by created_at? btw created_at is a timestamp, I just wrote '4pm' to make it a bit easier to read.
SELECT * FROM posts ORDER BY created_a, root_id, id; brian ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
