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
The former is easy, something like:
create function text(bool) returns text as 'select case when $1 then
''true'' else ''false'' end;' language 'sql';
I'm not entirely sure this is entirely safe for the latter, but you can
create function numericout(numeric) returns int as 'numeric_out' language
create function text(numeric) returns text as 'select
textin(numericout($1));' language 'sql';
In response to
pgsql-bugs by date
|Next:||From: Vicktor||Date: 2001-11-28 17:30:05|
|Subject: Re: text(bool), text(numeric)|
|Previous:||From: Markus Bertheau||Date: 2001-11-28 13:49:34|
|Subject: Re: Bug report.|