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

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/

[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