Re: DISTINCT ... ORDER BY

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: DISTINCT ... ORDER BY
Date: 2003-11-06 02:29:40
Message-ID: 20031106022940.GA12926@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Nov 05, 2003 at 22:27:40 +0100,
Nabil Sayegh <postgresql(at)e-trolley(dot)de> wrote:
> Bruno Wolff III wrote:
> >On Wed, Nov 05, 2003 at 21:06:30 +0100,
> > Nabil Sayegh <postgresql(at)e-trolley(dot)de> wrote:
> >
> >>Ok, let's look for alternatives.
> >
> >
> >Did you try my corrected suggestion?
>
> Yes, and it worked, thanks.
> But then I was too afraid of it being non-deterministic :(
>
> Is this query deterministic?

You will always get the same output order for a table with a given set of
rows in it.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sam 2003-11-06 11:15:54 NOVICE - first time trigger and function
Previous Message Nabil Sayegh 2003-11-06 02:03:30 Re: DISTINCT ... ORDER BY