Re: Selecting tree data

Pat Maddox wrote:
> On 10/26/07, brian <brian@zijn-digital.com> 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