Re: [HACKERS] Aggregation question

2004-05-08 Thread Oleg Bartunov
On Sat, 7 Feb 2004, [ISO-8859-1] Hans-J?rgen Sch?nig wrote: > if you want to put 1000 columns into one table, your data structure > needs some further investigation. you are trying to solve the wrong problem. Dilip, you may try our contrib/hstore from http://www.sai.msu.su/~megera/postgres/gist/

Re: [HACKERS] Aggregation question

2004-05-08 Thread Hans-Jürgen Schönig
if you want to put 1000 columns into one table, your data structure needs some further investigation. you are trying to solve the wrong problem. Regards, Hans Dilip Angal wrote: Hi I have a situation that I need flexible number columns to model the business requirements. It could go up to

Re: [HACKERS] Aggregation question

2004-02-07 Thread Bruno Wolff III
On Tue, Feb 03, 2004 at 21:27:48 -0800, Dilip Angal <[EMAIL PROTECTED]> wrote: > Hi > > I have a situation that I need flexible number columns to model the business > requirements. It could go up to 1000 columns and will be a sparse matrix. One option > I was considering was to have a table wi

[HACKERS] Aggregation question

2004-02-07 Thread Dilip Angal
Hi   I have a situation that I need flexible number columns to model the business requirements. It could go up to 1000 columns and will be a sparse matrix. One option I was considering was to have a table with col1..col1000 Other option I can consider is store all of them as name value