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