Postgres Pro
Downloads
Home   >   mailing lists

Casting numeric to text - Mailing list pgsql-sql

From Hans-Jürgen Schönig
Subject Casting numeric to text
Date
Msg-id 3ACDA3A6.B49C0D8C@cybertec.at
Whole thread Raw
Responses Re: Casting numeric to text
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Need help with EXECUTE function
Next
From: "comp"
Date:
Subject: Sql error