Yes! You are right! Now must me find out how to convert char* to numeric
datum and double to numeric datum and numeric datum to double :)
=?ISO-8859-2?Q?Dud=E1s_J=F3zsef?= <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
