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
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
-