Re: Bug? Changing where distinct occurs produces error? - Mailing list pgsql-general

From Michael Loftis
Subject Re: Bug? Changing where distinct occurs produces error?
Date
Msg-id 40756E28F09780CFFA962D56@d216-220-25-20.dynip.modwest.com
Whole thread Raw
In response to Bug? Changing where distinct occurs produces error?  (Michael Loftis <mloftis@wgops.com>)
List pgsql-general

--On July 7, 2006 3:22:01 PM -0700 Richard Broersma Jr
<rabroersma@yahoo.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!

pgsql-general by date:

Previous
From: lanczos@t-zones.sk
Date:
Subject: re: How to insert .xls files into database
Next
From: "John D. Burger"
Date:
Subject: Re: How to insert .xls files into database