[GENERAL] array_agg and partition sorts

2013-06-26 Thread Rory Campbell-Lange
I'm on Postgres 9.1 and I've come across an issue which shows I don't understand partition sorting: Given a table like this: select * from test; n_group | t_name| t_additional -+-+-- 1 | Canberra| Australia 1 | Vienna

Re: [GENERAL] array_agg and partition sorts

2013-06-26 Thread Rory Campbell-Lange
On 26/06/13, Rory Campbell-Lange (r...@campbell-lange.net) wrote: I'm on Postgres 9.1 and I've come across an issue which shows I don't understand partition sorting: Returns: -[ RECORD 1 ]- agg1