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