Re: how do the pro's do this? (still a newbie)
От | Simeo Reig |
---|---|
Тема | Re: how do the pro's do this? (still a newbie) |
Дата | |
Msg-id | 004201c16150$4b3b25d0$0a00a8c0@win2000 обсуждение исходный текст |
Ответ на | how do the pro's do this? (still a newbie) (Gunnar Lindholm <gunnar@gunix.mine.nu>) |
Список | pgsql-general |
try this http://www.brasileiro.net/postgres/plpgsql/ -- Simeó Reig ----- Original Message ----- From: "Gunnar Lindholm" <gunnar@gunix.mine.nu> To: <pgsql-general@postgresql.org> Sent: Tuesday, October 30, 2001 1:11 PM Subject: [GENERAL] how do the pro's do this? (still a newbie) > 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. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
В списке pgsql-general по дате отправления: