From: | Markus Orlich <markus(at)orlich(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org (PostgreSQL General) |
Subject: | [General] How could it work? |
Date: | 2002-04-09 09:07:04 |
Message-ID: | 20020409090704.GA2096@orlich.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Markus
--
There is no spam like no spam..
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2002-04-09 10:44:16 | Re: [General] How could it work? |
Previous Message | Mark kirkwood | 2002-04-09 08:37:12 | Re: [HACKERS] Re : Solaris Performance - Profiling |