how do the pro's do this? (still a newbie) - Mailing list pgsql-general

From Gunnar Lindholm
Subject how do the pro's do this? (still a newbie)
Date
Msg-id 01103013113901.00334@fire
Whole thread Raw
Responses Re: how do the pro's do this? (still a newbie)  (Tod McQuillin <devin@spamcop.net>)
List 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.

pgsql-general by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: [HACKERS] Serious performance problem
Next
From: Jean-Michel POURE
Date:
Subject: Re: [HACKERS] Serious performance problem