Re: Add absolute value to dict_int

2020-03-10 Thread Tom Lane
I wrote: > So all we really need to do is upgrade [de]serialize_deflist to be smarter > about int and float nodes. This is still a bit invasive because somebody > decided to make deserialize_deflist serve two masters, and I don't feel > like working through whether the prsheadline code would cope

Re: Add absolute value to dict_int

2020-03-09 Thread Tom Lane
I wrote: > There are at least three things we could do here: > 1. Insist that defGetBoolean and its siblings should accept the > string equivalent of any non-string value they accept. This > would change the behavior of a whole lot of utility commands, > not only the text search commands, and I'm

Re: Add absolute value to dict_int

2020-03-08 Thread Tom Lane
Jeff Janes writes: > I've seen a few requests on how to make FTS search on the absolute value of > integers. This question is usually driven by the fact that the text search > parser interprets a separating hyphen ("partnumber-987") as a minus sign. > There is currently no good answer for this t