Re: Pl/PgsSQL array

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ben-Nes Yonatan <da(at)canaan(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pl/PgsSQL array
Date: 2005-07-07 07:30:30
Message-ID: 42CCDA16.8030104@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ben-Nes Yonatan wrote:
> Richard Huxton wrote:
>
>>> Can anyone tell me if Pl/PgSQL can support a multi dimensional array
>>> (of up to 5 levels top I guess) with about 100,000 values?
>>> and does it stress the system too much?
>>
>> I can't imagine it being wonderful - you probably want a different
>> procedural language. Or a different approach come to think of it - can
>> I ask what you are using 5D arrays with 100,000 values for?
>
> Indeed you can my good sir :)
>
> Im going to insert into one table a list of about 3.5 million products
> each day, thouse products also contain data about their own categories.
>
> Now I receive all of this data every day and I need to delete all of the
> previous data each time and insert the new one.
> In order to create the category table (tree table) I want to create an
> array out of the categories information at the products and then insert
> it into the the categories table (the tree :)).

I would be tempted use an external perl script to receive the data and
insert it into the database, building the categories tree as it did so.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben-Nes Yonatan 2005-07-07 11:14:33 Re: Pl/PgsSQL array
Previous Message Rob Brenart 2005-07-07 04:23:51 Looking for a good ERD Tool