Re: [HACKERS] DISTINCT and ORDER BY bug?

From: Chris <chris(at)bitmead(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Don Baccus <dhogaza(at)pacifier(dot)com>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] DISTINCT and ORDER BY bug?
Date: 2000-02-07 08:31:14
Message-ID: 389E82D2.65784CF@bitmead.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> select distinct x from foo order by y;
>
> which produces ill-defined results.

Why is this ill-defined? If y is in x then it is also distinct and
there's no logic problem sorting on it.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris 2000-02-07 08:42:38 Re: [HACKERS] ONLY
Previous Message Ansley, Michael 2000-02-07 07:42:13 RE: [HACKERS] ONLY