Casting numeric to text

From: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: Casting numeric to text
Date: 2001-04-06 11:08:22
Message-ID: 3ACDA3A6.B49C0D8C@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message juerg.rietmann 2001-04-06 12:10:15 how to do this join ?
Previous Message Richard Huxton 2001-04-06 08:54:40 Re: Index on View ?