Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes:
> I should cast field of 'text' type to the 'numeric' type,
> but PG output error message: "ERROR: Cannot cast type 'text' to
> 'numeric'".
This has been fixed for 7.3.
> Imho, almost all types should have default convertors from and to
> the 'tex
Hi,
I should cast field of 'text' type to the 'numeric' type,
but PG output error message: "ERROR: Cannot cast type 'text' to
'numeric'".
I had tried to use conversion to type 'float' and all works good,
and now I must write quaries like next one:
SELECT price::float::numeric FROM price
