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

Re: text(bool), text(numeric)

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: Vicktor <vic(at)adv(dot)ru>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: text(bool), text(numeric)
Date: 2001-11-28 11:31:25
Message-ID: 20011128123124.D7597@zf.jcu.cz (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, Nov 28, 2001 at 12:00:44PM +0100, Markus Bertheau wrote:
> 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.

 I mean original questioner has other problem:

t=# SELECT 't'::bool::text;
ERROR:  Cannot cast type 'boolean' to 'text'
test=# SELECT '123'::numeric::text;
ERROR:  Cannot cast type 'numeric' to 'text'
test=#

        Karel
-- 
 Karel Zak  <zakkr(at)zf(dot)jcu(dot)cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

pgsql-bugs by date

Next:From: Markus BertheauDate: 2001-11-28 13:49:34
Subject: Re: Bug report.
Previous:From: VicktorDate: 2001-11-28 11:26:45
Subject: Re: text(bool), text(numeric)

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