Re: DISTINCT ... ORDER BY - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: DISTINCT ... ORDER BY
Date
Msg-id 20031106022940.GA12926@wolff.to
Whole thread Raw
In response to Re: DISTINCT ... ORDER BY  (Nabil Sayegh <postgresql@e-trolley.de>)
List pgsql-novice
On Wed, Nov 05, 2003 at 22:27:40 +0100,
  Nabil Sayegh <postgresql@e-trolley.de> wrote:
> Bruno Wolff III wrote:
> >On Wed, Nov 05, 2003 at 21:06:30 +0100,
> >  Nabil Sayegh <postgresql@e-trolley.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.

pgsql-novice by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: DISTINCT ... ORDER BY
Next
From: "Robert C. Mosher II"
Date:
Subject: Giving a user a database