Re: Selecting tree data

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

That doesn't work because it just sorts by created_at, and then if two
records are the same it goes to root_id.  That's not what I want.

Pat