Re: [HACKERS] "pivot aggregation" with a patched intarray

2014-06-05 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 : > > I'm thinking about adding a final function to my aggregat

Re: [HACKERS] "pivot aggregation" with a patched intarray

2014-06-05 Thread Ali Akbar
2014-06-05 17:18 GMT+07:00 Marc Mamin : > 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 probably degrade the

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 > > 201

Re: [HACKERS] "pivot aggregation" with a patched intarray

2014-06-04 Thread Ali Akbar
2014-06-01 20:48 GMT+07:00 Marc Mamin : > > >On Sat, May 31, 2014 at 12:31 AM, Marc Mamin 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 o

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 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 feature it

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 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 feature itself, bu

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 an

[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 man