'plpgsql' oddity
От | Mitch Vincent |
---|---|
Тема | 'plpgsql' oddity |
Дата | |
Msg-id | 008701c084dc$9d0cb0a0$0200000a@windows обсуждение исходный текст |
Ответы |
Re: 'plpgsql' oddity
Re: 'plpgsql' oddity |
Список | pgsql-general |
This is probably something I'm doing (or not doing) but I can't seem to figure out what it is... I have been playing with this little function : CREATE FUNCTION invoice_payment() RETURNS OPAQUE AS ' BEGIN UPDATE invoice_master SET total = total - NEW.amount,updated = ''now'' WHERE invoice_id = NEW.invoice_id; RETURN NEW; END; ' LANGUAGE 'plpgsql'; .. and this trigger : CREATE TRIGGER invoice_trigger AFTER INSERT ON invoice_payments FOR EACH ROW EXECUTE PROCEDURE invoice_payment(); The first field to be updated (total to total - amount) works just fine but anything I put after that simply doesn't happen, it's very strange.. In the above example, total gets updated but the field 'updated' does not, yet the query does run (and correctly as far as the total field goes) so I'm assuming there isn't a parse error or anything.. Can someone smack me with a clue stick? Thanks! -Mitch
В списке pgsql-general по дате отправления: