Vicktor writes:
> Why not exists functions for convert any type to text?
> I can't find text(bool), text(numeric) ...
Just because *some* mapping between data types exists it doesn't mean it's
the sound, well-defined, be-all-end-all. For instance, one might think
that TRUE => 't' and FALSE =>
On Wed, 28 Nov 2001 08:35:00 -0800 (PST)
Stephan Szabo <[EMAIL PROTECTED]> wrote:
Ok, thank !
Vicktor
> On Wed, 28 Nov 2001, Vicktor wrote:
>
> > Hello All,
> >
> > Why not exists functions for convert any type to text?
> > I can't find text(bool), text(numeric) ...
> > May be it posiible
On Wed, 28 Nov 2001, Vicktor wrote:
> Hello All,
>
> Why not exists functions for convert any type to text?
> I can't find text(bool), text(numeric) ...
> May be it posiible in 7.2?
Don't think so. You need those functions and noone has written
them officially.
The former is easy, something
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
On 28 Nov 2001 12:00:44 +0100
Markus Bertheau <[EMAIL PROTECTED]> 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 cas
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
msg03163/pgp0.pgp
Description: PGP s
Hello All,
Why not exists functions for convert any type to text?
I can't find text(bool), text(numeric) ...
May be it posiible in 7.2?
Victor
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(s
