[General] How could it work?

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

Responses

Browse pgsql-general by date

  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