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