Обсуждение: GROUP BY array

Поиск
Список
Период
Сортировка

GROUP BY array

От
Andrey Mosienko
Дата:
Hello All!

I am using arrays in my database widely.
When it will be possible to do: GROUP BY some_array?

As I read in 7.3 ORDER BY some_array will appear. Am I right?

--
Best regards Andrey Feofilactovich
e-mail: feo@ttn.ru, feo@feo.org.ru


Re: GROUP BY array

От
Tom Lane
Дата:
Andrey Mosienko <feo@feo.org.ru> writes:
> When it will be possible to do: GROUP BY some_array?

GROUP BY (also ORDER BY) will work on any datatype that has '<'
and '=' operators.

> As I read in 7.3 ORDER BY some_array will appear. Am I right?

Dunno where you read that.  AFAIK there is nothing in 7.3 for array '<'.
But you could write it yourself ...

            regards, tom lane