Cast boolean to text

From: "Willy-Bas Loos" <willybas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Cast boolean to text
Date: 2006-12-07 09:08:50
Message-ID: 1dd6057e0612070108j62cc1bb8j9a579e7de1791719@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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".

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2006-12-07 09:13:06 Re: dynamic SQL - variable substitution in plpgsql
Previous Message Alban Hertroys 2006-12-07 09:06:17 Re: From Clause