[GENERAL] automatic type cast to numeric ?

2001-02-03 Thread Peter Vazsonyi
Gretings! I try to change from using of float8 to numeric... For quantitative calculations and storage the float8 wasn't the best choice;) For some reasons i need automatic or explicit type cast from text to numeric and vice versa. But: test=# select '123'::text::numeric; ERROR: Cannot cast type

[GENERAL] Triggered data change violation

2001-03-02 Thread Peter Vazsonyi
Hello! I have a table, with an update trigger (it change the value of 'last_modify' field to current timestamp) Sometimes if i try delete rows in this table (before delete, there are some inserts after a 'begin') i get this change violation error. I don't now why. Can somebody help me? Thank's -