Re: Cast boolean to text

You can create a cast like this:

*create or replace function bool_to_text (boolean)
returns char
strict
language sql as '
select case
when $1 then \'t\'
else \'f\'
end;
';

create cast (boolean as char(1))
with function bool_to_text(boolean)
as implicit;
*
Thank you,
Shoaib

On 12/7/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Willy-Bas Loos" <willybas(at)gmail(dot)com> writes:
> > I've noticed that postgresql 8.1.0 can cast a boolean to text, but
> version
> > 8.1.5 CAN'T.
>
> Better check again --- there has never been a standard cast from bool to
> text. Sure you didn't install a custom one in your 8.1.0 database?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>