Re: Bug? Changing where distinct occurs produces error?

From: Michael Loftis <mloftis(at)wgops(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Bug? Changing where distinct occurs produces error?
Date: 2006-07-07 23:44:26
Message-ID: 40756E28F09780CFFA962D56@d216-220-25-20.dynip.modwest.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--On July 7, 2006 3:22:01 PM -0700 Richard Broersma Jr
<rabroersma(at)yahoo(dot)com> wrote:

> Notice: http://www.postgresql.org/docs/8.1/interactive/sql-select.html
>
> According to the syntax for a select a distinct | distinct on must be the
> first column specified in the syntax.
>
> So perhaps it is designed that way.

Ahhh I see, I keep thinking of DISTINCT as a Aggregator function. That's
my mistake.

Thanks all!

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2006-07-08 01:01:43 Re: How to insert .xls files into database
Previous Message lanczos 2006-07-07 22:41:40 re: How to insert .xls files into database