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 in 7.2? > > Don't think so. You need those functions and noone has written > them officially. > > The former is easy, something like: > > create function text(bool) returns text as 'select case when $1 then > ''true'' else ''false'' end;' language 'sql'; > > should suffice. > > > I'm not entirely sure this is entirely safe for the latter, but you can > try :) > > create function numericout(numeric) returns int as 'numeric_out' language > 'internal'; > create function text(numeric) returns text as 'select > textin(numericout($1));' language 'sql'; > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
