Skip site navigation (1) Skip section navigation (2)

Re: Bug #775: Unable to identify an operator '=' for types 'numeric' and 'double precision'

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: daniel(at)checkforte(dot)com(dot)br, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #775: Unable to identify an operator '=' for types 'numeric' and 'double precision'
Date: 2002-09-19 21:14:00
Message-ID: 3211.1032470040@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org writes:
>  Unable to identify an operator '=' for types 'numeric' and 'double precision'

At the moment you have to cast the literal to numeric (or cast the
column to float8, if you'd rather use float arithmetic, which I
imagine you wouldn't).  The existing parser doesn't see any reason
to prefer either choice over the other, so it throws up its hands.

In 7.3 I expect this will behave the way you'd like.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: David ChristianDate: 2002-09-19 22:03:32
Subject: Re: Server hangs on multiple connections
Previous:From: Tom LaneDate: 2002-09-19 21:10:40
Subject: Re: Server hangs on multiple connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group