[SQL] Casting numeric to text

[Hans-J�rgen Sch�nig]

Is there any possibility to cast numeric to text in Postgres 7.0.3?

shop=# select cast(price as text) from products;
ERROR:  Cannot cast type 'numeric' to 'text'

    Hans


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster