Re: [GENERAL] Putting many related fields as an array

2009-05-12 Thread Andrew Gould
On Tue, May 12, 2009 at 7:06 AM, Ow Mun Heng wrote: > -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > On Tue, May 12, 2009 at 01:23:14PM +0800, Ow Mun Heng wrote: > >> | sum of count | sum_of_count_squared | qty | qty < 100 | qty < 500 | > >> > >> >

Re: [GENERAL] Putting many related fields as an array

2009-05-12 Thread Sam Mason
On Tue, May 12, 2009 at 08:06:25PM +0800, Ow Mun Heng wrote: > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > On Tue, May 12, 2009 at 01:23:14PM +0800, Ow Mun Heng wrote: > >Not sure why this is better than using separate columns though. Maybe a > >new datatype and a custom aggr

Re: [GENERAL] Putting many related fields as an array

2009-05-12 Thread Ow Mun Heng
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- On Tue, May 12, 2009 at 01:23:14PM +0800, Ow Mun Heng wrote: >> | sum of count | sum_of_count_squared | qty | qty < 100 | qty < 500 | >> >> >> I'm thinking of lumping them into 1 column via an array instead

Re: [GENERAL] Putting many related fields as an array

2009-05-12 Thread Sam Mason
On Tue, May 12, 2009 at 01:23:14PM +0800, Ow Mun Heng wrote: > | sum of count | sum_of_count_squared | qty | qty < 100 | qty < 500 | > > > I'm thinking of lumping them into 1 column via an array instead of into > 5 different columns. Not sure how to go about this, hence the email to > the list.

[GENERAL] Putting many related fields as an array

2009-05-11 Thread Ow Mun Heng
Hi, Currently doing some level of aggregrate tables for some data. These data will be used for slice/dice activity and we want to be able to play/manipulate the data such that I can get means and stddev data. Eg: For each Original Column eg: population_in_town : (I get derivatives) - mean # of