Re: [SQL] GROUP BY: v6.1 vs. v6.5.2

From: Ray Plante <rplante(at)poplar(dot)astro(dot)uiuc(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ray Plante <rplante(at)ncsa(dot)uiuc(dot)edu>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] GROUP BY: v6.1 vs. v6.5.2
Date: 2000-02-01 17:06:20
Message-ID: Pine.SGI.4.05.10002011006060.154408-100000@poplar.astro.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Tom,

> What you can do at the moment is
>
> select distinct on x x, y from table;
>
> This is nonstandard, klugy, and just as unpredictable as the old GROUP
> BY behavior, but you only need an ordering operator on x.

Excellent. This is just the short-term solution I can use until I work
out a permanent one. Thanks!

Ray

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message a kj 2000-02-02 14:09:32 Hello sir.
Previous Message Tom Lane 2000-02-01 03:03:27 Re: [SQL] GROUP BY: v6.1 vs. v6.5.2