From: | "Shoaib Mir" <shoaibmir(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Willy-Bas Loos" <willybas(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Cast boolean to text |
Date: | 2006-12-08 05:07:31 |
Message-ID: | bf54be870612072107x587204f8u1d86046dc4270556@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick TJ McPhee | 2006-12-08 05:20:23 | Re: Restore database from files (not dump files)? |
Previous Message | Scott Ribe | 2006-12-08 03:46:23 | Re: Restore database from files (not dump files)? |