From: | Gunnar Lindholm <gunnar(at)gunix(dot)mine(dot)nu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | how do the pro's do this? (still a newbie) |
Date: | 2001-10-30 12:11:39 |
Message-ID: | 01103013113901.00334@fire |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello.
As a newbie in the stored procedure programming area I would like to know how
you could do the following with a function in plpgsql.
(It's a theoretical question, so do not suggest changing the tables :-)
I have
table A :
id integer primary key default nextval('something'),
dohA integer
table B:
rid integer references A,
dohB integer
and I wish to create a function "foo( dohA, dohB)" that inserts the values
dohA and dohB into the proper tables A and B and the reference in table B
should of course be connected to the PK in table A. You understand what I
mean, right?
Now, how do I write
function foo(integer, integer)
begin work
... please fill this space with some code.... !!!!
commit
Is there some realy good tutorial on this, please tell me so?
TIA, Gunnar.
From | Date | Subject | |
---|---|---|---|
Next Message | Tille, Andreas | 2001-10-30 12:17:18 | Re: [HACKERS] Serious performance problem |
Previous Message | Jean-Michel POURE | 2001-10-30 12:10:18 | Re: [HACKERS] Serious performance problem |