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

Re: text(bool), text(numeric)

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Vicktor <vic(at)adv(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: text(bool), text(numeric)
Date: 2001-11-28 11:00:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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

In response to


pgsql-bugs by date

Next:From: VicktorDate: 2001-11-28 11:26:45
Subject: Re: text(bool), text(numeric)
Previous:From: VicktorDate: 2001-11-28 10:24:29
Subject: text(bool), text(numeric)

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