Re: [SQL] Problem with function & trigger

2001-07-09 Thread Carlo Vitolo
Tom Lane wrote: > Carlo Vitolo <[EMAIL PROTECTED]> writes: > > This does not work. The error is ERROR: pg_atoi: error in "12.00": can't > > parse ".00" > > What PG version are you running? It seems to work fine for me in > current sources

[SQL] Problem with function & trigger

2001-07-07 Thread Carlo Vitolo
This does not work. The error is ERROR: pg_atoi: error in "12.00": can't parse ".00" CREATE FUNCTION "togliscar" () RETURNS opaque AS 'BEGIN UPDATE magazzino SET quantita = (SELECT quantita FROM magazzino WHERE descrizione = NEW.descrizione ) - NEW.quantita WHERE descrizione = NEW.descrizione; RE