Pat Maddox wrote:
> On 10/26/07, brian <brian(at)zijn-digital(dot)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