| 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: | Whole Thread | Raw Message | 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 |