Re: Disabling inferred "group by" columns in 9.1? - Mailing list pgsql-general

From Evan D. Hoffman
Subject Re: Disabling inferred "group by" columns in 9.1?
Date
Msg-id CABRB-Ls5n8cYwexa0yS9DJfwWAvP4sMPQh2kmaBV8296+cMKvg@mail.gmail.com
Whole thread Raw
In response to Re: Disabling inferred "group by" columns in 9.1?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Disabling inferred "group by" columns in 9.1?
Re: Disabling inferred "group by" columns in 9.1?
List pgsql-general
Because we have both 9.0 and 9.1 running, and a query that succeeds
under 9.1 was failing under 9.0.  Can I assume the answer then is
"no"?

On Thu, Oct 11, 2012 at 2:38 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Evan D. Hoffman" <evandhoffman@gmail.com> writes:
>> Is there any way to disable the guessing of missing columns in a
>> group-by (the feature added in 9.1)?
>
> Why would you want to do that?  There's no "guessing" involved: the
> behavior is always correct, and it is required by the SQL standard.
>
>                         regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disabling inferred "group by" columns in 9.1?
Next
From: Thomas Kellerer
Date:
Subject: Re: Disabling inferred "group by" columns in 9.1?