Skip site navigation (1) Skip section navigation (2)

Re: text(bool), text(numeric)

From: Vicktor <vic(at)adv(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: text(bool), text(numeric)
Date: 2001-11-28 11:26:45
Message-ID: 20011128142645.39b1e435.vic@adv.ru (view raw or flat)
Thread:
Lists: pgsql-bugs
On 28 Nov 2001 12:00:44 +0100
Markus Bertheau <twanger(at)bluetwanger(dot)de> wrote:

It's not work when column is bool or numeric type !

> On Wed, 2001-11-28 at 11:24, Vicktor wrote:
> >  Why not exists functions for convert any type to text?
> >  I can't find text(bool), text(numeric) ...
> 
> use type casting: 
> 
> select column::text from table
> 
> after :: comes the type you want.
> 
> Markus Bertheau
> 
> 
> 
> 

Victor

In response to

pgsql-bugs by date

Next:From: Karel ZakDate: 2001-11-28 11:31:25
Subject: Re: text(bool), text(numeric)
Previous:From: Markus BertheauDate: 2001-11-28 11:00:44
Subject: Re: text(bool), text(numeric)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group