GROUP BY array

Started by Andrey Mosienkoover 23 years ago2 messagesgeneral
Jump to latest
#1Andrey Mosienko
feo@feo.org.ru

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Andrey Mosienko (#1)
Re: GROUP BY array

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