Re: Recasting data type

On Wed, Feb 07, 2001 at 11:31:43AM -0800, Conrad Schuler wrote:
> Hi All,
>
> Thanks for the help on the 'lumper' vs. 'splitter' question.
>
> I asked my practice database:
>
> select count (*) from titles where price > 20
>
> It responded:
>
> PostgreSQL said: ERROR: Unable to identify an operator '>' for types
> 'money' and 'int4' You will have to retype this query using an explicit cast
>
> I tried variations on this theme and got nowhere:
> select count (*) from titles cast(price as float8) where price > 20

Why don't you try:

select count(*) from titles where price > 20.00

It seems that the explicit decimal should automatically cause the
cast. I'm not positive it will work, but it's worth a try.

--
Dr. David C. Merrill http://www.lupercalia.net
Linux Documentation Project david(at)lupercalia(dot)net
Collection Editor & Coordinator http://www.linuxdoc.org
Finger me for my public key

One seldom sees a monument to a committee.