Re: Disabling inferred "group by" columns in 9.1?

From: "Evan D(dot) Hoffman" <evandhoffman(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Postgresql Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Disabling inferred "group by" columns in 9.1?
Date: 2012-10-11 18:54:19
Message-ID: CABRB-Ls5n8cYwexa0yS9DJfwWAvP4sMPQh2kmaBV8296+cMKvg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Evan D. Hoffman" <evandhoffman(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2012-10-11 19:04:47 Re: Disabling inferred "group by" columns in 9.1?
Previous Message Tom Lane 2012-10-11 18:38:32 Re: Disabling inferred "group by" columns in 9.1?