On Mon, May 22, 2006 at 18:38:35 -0400,
Tom Lane <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III <[EMAIL PROTECTED]> writes:
> > On Mon, May 22, 2006 at 10:23:28 +0200,
> > Albe Laurenz <[EMAIL PROTECTED]> wrote:
> >> In order to (efficiently) process a GROUP BY clause, you need a
> >> total order
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> On Mon, May 22, 2006 at 10:23:28 +0200,
> Albe Laurenz <[EMAIL PROTECTED]> wrote:
>> In order to (efficiently) process a GROUP BY clause, you need a
>> total ordering on the data type that you group by, i.e. an ordering
>> such that for any two data x
On Mon, May 22, 2006 at 10:23:28 +0200,
Albe Laurenz <[EMAIL PROTECTED]> wrote:
>
> In order to (efficiently) process a GROUP BY clause, you need a
> total ordering on the data type that you group by, i.e. an ordering
> such that for any two data x and y you have either x < y or x > x
> or x = y
Jaime Casanova wrote:
> suppose we have something like this:
>
> upd_views=# create table tabla1 (col1 point);
[...]
> then, this select will give an error:
>
> upd_views=# select col1, count(*) from tabla1 group by col1;
> ERROR: could not identify an ordering operator for type point
> HINT: