Re: text(bool), text(numeric)

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@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz