Re: [GENERAL] space required before negative

2016-03-04 Thread Geoff Winkless
On 3 March 2016 at 17:30, Tom Lane wrote: > That's a syntax issue, so the place to look is > http://www.postgresql.org/docs/9.5/static/sql-syntax-lexical.html#SQL-SYNTAX-OPERATORS Ah, thanks. Perhaps a note in the operators page might be helpful? I'll change to use <> in place of !=; quite apart

Re: [GENERAL] space required before negative

2016-03-03 Thread Tom Lane
Geoff Winkless writes: > I was surprised to find that whitespace is required between the != > operator and a negative sign, otherwise postgres believes that I'm > intending !=- as an operator (I get "operator does not exist: integer > !=- integer"). > This isn't the case with <>-x. > Is this int

[GENERAL] space required before negative

2016-03-03 Thread Geoff Winkless
Hi I was surprised to find that whitespace is required between the != operator and a negative sign, otherwise postgres believes that I'm intending !=- as an operator (I get "operator does not exist: integer !=- integer"). This isn't the case with <>-x. Is this intentional? I couldn't find refere