You could do:
SELECT quantity::text FROM tblOrders
On 05/05/2009, at 8:21 AM, JORGE MALDONADO wrote:
> Is it possible to convert a numeric value to string within a SELECT
> query statement?
> For example, let's say that I have a table with a numeric field
> named "quantity". A normal SELECT would be "SELECT quantity FROM
> tblOrders". What if I want the value returned by the SELECT clause
> to be of type string instead of decimal?
> Jorge Maldonado
In response to
pgsql-novice by date
|Next:||From: Cliff Nieuwenhuis||Date: 2009-05-05 00:40:58|
|Subject: Re: hi|
|Previous:||From: JORGE MALDONADO||Date: 2009-05-04 22:21:49|
|Subject: DATA TYPE CONVERTION|