| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2001-11-28 11:31:25 | Re: text(bool), text(numeric) |
| Previous Message | Markus Bertheau | 2001-11-28 11:00:44 | Re: text(bool), text(numeric) |