Re: PL/pgSQL Question
От | Mitch Vincent |
---|---|
Тема | Re: PL/pgSQL Question |
Дата | |
Msg-id | 005501c084d0$0d9311a0$0200000a@windows обсуждение исходный текст |
Ответ на | PL/pgSQL Question ("Mitch Vincent" <mitch@venux.net>) |
Список | pgsql-general |
Er, I'm pretty sure I found what I was looking for, sorry to waste everyone's time.. I looked right past half the documentation! -Mitch ----- Original Message ----- From: "Mitch Vincent" <mitch@venux.net> To: <pgsql-general@postgresql.org> Sent: Monday, January 22, 2001 6:56 PM Subject: PL/pgSQL Question > I haven't used PL/pgSQL very much but it looks like a good language in which > to make some simple functions for this application I'm writing.. > > Is it possible (with PL/pgSQL) to access other records in other tables than > the tuple that pulled the trigger (and called the function)? > > Say this (pseudo code): > > When a record is added to the invoice_payments table have a trigger fire and > call this function : > > total_invoice() > > exec_sql -> UPDATE invoices SET total = total + <amount in amount_field in > the tuple> WHERE invoice_id=<value in the invoice ID of this tuple> > > > > That's basically all I'd have to do.. There are a lot of these things that > could be handled by the backend and would make my life much easier.. > > I looked in the documentation but the examples only talk about rearranging > values within the tuple that fired the trigger which called the function > (wow, a mouth full). > > Thanks! > > -Mitch > > >
В списке pgsql-general по дате отправления: