=?ISO-8859-2?Q?Dud=E1s_J=F3zsef?= <dj1999@xxxxxxxxxxx> writes: > Just have problem with this conversion from TEXT - double - Datum ( > NUMERIC ) where in TEXT is a number value forexample now the value is 1.00 NUMERIC? You didn't say anything about NUMERIC before. The code you posted thinks it is working with a FLOAT8 datum, which is just about entirely unlike NUMERIC. If you are trying to assign that to a table column that's declared as NUMERIC, then that type mismatch is exactly your problem. regards, tom lane