Re: [HACKERS] pivot aggregation with a patched intarray

2014-06-06 Thread Marc Mamin
From: Ali Akbar [mailto:the.ap...@gmail.com] Sent: Freitag, 6. Juni 2014 03:44 Subject: Re: [HACKERS] pivot aggregation with a patched intarray 2014-06-05 17:18 GMT+07:00 Marc Mamin m.ma...@intershop.de: I'm thinking about adding a final function to my aggregate that would replace zero

Re: [HACKERS] pivot aggregation with a patched intarray

2014-06-05 Thread Marc Mamin
-Original Message- From: Ali Akbar [mailto:the.ap...@gmail.com] Sent: Donnerstag, 5. Juni 2014 01:12 To: Marc Mamin Cc: Michael Paquier; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] pivot aggregation with a patched intarray 2014-06-01 20:48 GMT+07:00 Marc Mamin m.ma

Re: [HACKERS] pivot aggregation with a patched intarray

2014-06-05 Thread Ali Akbar
2014-06-05 17:18 GMT+07:00 Marc Mamin m.ma...@intershop.de: I'm thinking about adding a final function to my aggregate that would replace zero values will nulls, hence transforming the intarray into a standard int[], possibly with nullbitmap and a lowerbound that can be 1. This will

Re: [HACKERS] pivot aggregation with a patched intarray

2014-06-04 Thread Ali Akbar
2014-06-01 20:48 GMT+07:00 Marc Mamin m.ma...@intershop.de: On Sat, May 31, 2014 at 12:31 AM, Marc Mamin m.ma...@intershop.de wrote: I have patched intarray with 3 additional functions in order to count[distinct] event IDs into arrays, whereas the array position correspond to the integer

Re: [HACKERS] pivot aggregation with a patched intarray

2014-06-01 Thread Michael Paquier
On Sat, May 31, 2014 at 12:31 AM, Marc Mamin m.ma...@intershop.de wrote: I have patched intarray with 3 additional functions in order to count[distinct] event IDs into arrays, whereas the array position correspond to the integer values. (mimic column oriented storage) I didn't look at the

Re: [HACKERS] pivot aggregation with a patched intarray

2014-06-01 Thread Marc Mamin
On Sat, May 31, 2014 at 12:31 AM, Marc Mamin m.ma...@intershop.de wrote: I have patched intarray with 3 additional functions in order to count[distinct] event IDs into arrays, whereas the array position correspond to the integer values. (mimic column oriented storage) I didn't look at the

[HACKERS] pivot aggregation with a patched intarray

2014-05-30 Thread Marc Mamin
Hello, (sorry for this long post) I have patched intarray with 3 additional functions in order to count[distinct] event IDs into arrays, whereas the array position correspond to the integer values. (mimic column oriented storage) I need to use an array for the event IDs as I don't know how

Re: [HACKERS] pivot aggregation with a patched intarray

2014-05-30 Thread Marc Mamin
(reposted, this time with attachment. sorry) Hello, (sorry for this long post) I have patched intarray with 3 additional functions in order to count[distinct] event IDs into arrays, whereas the array position correspond to the integer values. (mimic column oriented storage) I need to use