how to create such a function??
| От | Ireneusz Kramarz |
|---|---|
| Тема | how to create such a function?? |
| Дата | |
| Msg-id | 001301c3b396$6849d000$0300a8c0@iron обсуждение исходный текст |
| Ответы |
Re: how to create such a function??
|
| Список | pgsql-novice |
Hi there,
I want to create a function and a trigger, but I don't know how... :(
I need something that would work when I update the table 'stock' , by insert some integer value into 'sold'. Then the integer value in field 'stock' has to be decreased by that inserted value.
example of my problem:
-table 'stock' before updating 'sold' field
ticket_id | stock | sold
1 | 30 | 0
-how table 'stock' should look like after: update stock set sold=2 where bilet_id=1;
ticket_id | stock | sold
1 | 28 | 2
I have to create something that would work like that, after each update of ticket_id defined rows.
I know that you guys can help me with that... apreciate any help which will be priceless ;-)
iron
В списке pgsql-novice по дате отправления: