Обсуждение: Cast boolean to text
Hi,
I've noticed that postgresql 8.1.0 can cast a boolean to text, but version 8.1.5 CAN'T.
Is this a bug or a feature?
as proof, try to run this query:
select 't'::bool::text
On version 8.1.5 one will recieve the error message "can't convert boolean to text".
I've noticed that postgresql 8.1.0 can cast a boolean to text, but version 8.1.5 CAN'T.
Is this a bug or a feature?
as proof, try to run this query:
select 't'::bool::text
On version 8.1.5 one will recieve the error message "can't convert boolean to text".
You can create a custome cast for this purpose that can convert bool to text...
Regards,
Shoaib
On 12/7/06, Willy-Bas Loos <willybas@gmail.com> wrote:
Hi,
I've noticed that postgresql 8.1.0 can cast a boolean to text, but version 8.1.5 CAN'T.
Is this a bug or a feature?
as proof, try to run this query:
select 't'::bool::text
On version 8.1.5 one will recieve the error message "can't convert boolean to text".
"Willy-Bas Loos" <willybas@gmail.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
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;
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@sss.pgh.pa.us> wrote:
"Willy-Bas Loos" <willybas@gmail.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