Vic wrote:

>  Hi
>   I try  this  "construction"  : select myfield from mytable  where
> myfield=-1
> And get  this:
> ERROR:  Unable to identify an operator '=-' for types 'numeric' and
> 'int4'

What version of PostgreSQL are you using ?

I believe this is fixed a long time ago.

If you don't want to upgrade just put spaces in

 > select myfield from mytable  where myfield = -1

----------------
Hannu

In response to

• Oops! Its bug in parser???? at 2001-03-05 08:33:35 from Vic

Responses

• Re: Oops! Its bug in parser???? at 2001-03-05 12:01:33 from Vic

pgsql-hackers by date

Next:	From: Christof Petig	Date: 2001-03-05 14:00:47
	Subject: Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3
Previous:	From: Vic	Date: 2001-03-05 12:01:33
	Subject: Re: Oops! Its bug in parser????