From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [General] How could it work? |
Date: | 2002-04-09 10:44:16 |
Message-ID: | 20020409204416.D7291@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Apr 09, 2002 at 11:07:04AM +0200, Markus Orlich wrote:
> Suppose you have tables like this:
> table_1 tmp_store tmp_article
> +---------+----------+ +---------+----------+ +---------+----------+
> | name | type | | name | type | | name | type |
> +---------+----------+ +---------+----------+ +---------+----------+
> | dat | date | | dat | date | | dat | date |
> | store | char | | article | char | | store | char |
> | article | char | | price | money | | price | money |
> | price | money | | amount | smallint | | amount | smallint |
> | amount | smallint | +---------+----------+ +---------+----------+
> +---------+----------+
>
> and an insert like this:
> insert into table_1 values ( '08/04/2002', 'aldi', 'hmilch', 0.57, 3 );
>
> Is it possible for each insert
> 1. verify if a table exists with the name of the (store|article)
> if yes
> a. insert the relevant data
> if no
> a. create a table (store|article) like (tmp_store|tmp_article)
> b. insert the relevant data
>
> I was reading about triggers and functions, but I havn't found an answer
> how to create tables in triggers or in functions.
Umm, why create tables? Why not have a table with all the stores and a table
with all the articles? I think your database needs a little more design, as
the number of tables should remain almost constant during normal usage.
Besides, lots of small tables is rather in efficient.
HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Ignorance continues to thrive when intelligent people choose to do
> nothing. Speaking out against censorship and ignorance is the imperative
> of all intelligent people.
From | Date | Subject | |
---|---|---|---|
Next Message | Papp, Gyozo | 2002-04-09 12:45:59 | SPI_execp() failed in RI_FKey_cascade_del() |
Previous Message | Markus Orlich | 2002-04-09 09:07:04 | [General] How could it work? |