Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group