Re: [HACKERS] Oops! Its bug in parser????

2001-03-05 Thread Tom Lane
Vic <[EMAIL PROTECTED]> writes: >> What version of PostgreSQL are you using ? > PostgreSQL 7.0.0 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 Evidently not a released version, but some beta, since this behavior was changed before 7.0 release (cf. scan.l CVS log for 18-Mar-2000). I *stron

Re: [HACKERS] Oops! Its bug in parser????

2001-03-05 Thread Vic
> What version of PostgreSQL are you using ? > PostgreSQL 7.0.0 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 > > 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 Ya - i don't want make upgra

Re: [HACKERS] Oops! Its bug in parser????

2001-03-05 Thread Hannu Krosing
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 w

[HACKERS] Oops! Its bug in parser????

2001-03-05 Thread Vic
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' You will have to retype this query using an explicit cast I don't lik this! Vic ---(end o