Re: [GENERAL] Can't find documentation for ~=~ operator

2009-10-16 Thread Viktor Rosenfeld
Tom Lane wrote: Viktor Rosenfeld listuse...@googlemail.com writes: I can't find the documentation of the ~=~ operator anywhere on the PostgreSQL homepage. Which version's documentation are you reading? It's gone as of 8.4. I realize that, but I have to use 8.3 right now and can't find

[GENERAL] Can't find documentation for ~=~ operator

2009-10-15 Thread Viktor Rosenfeld
Hi, I can't find the documentation of the ~=~ operator anywhere on the PostgreSQL homepage. I'm quite certain that I saw it there a while ago, though. FYI, I use ~=~ for equality checks, so I can use the same index for equality and regexp pattern matching on a varchar field. The index is built

Re: [GENERAL] Can't find documentation for ~=~ operator

2009-10-15 Thread Tom Lane
Viktor Rosenfeld listuse...@googlemail.com writes: I can't find the documentation of the ~=~ operator anywhere on the PostgreSQL homepage. Which version's documentation are you reading? It's gone as of 8.4. FYI, I use ~=~ for equality checks, so I can use the same index for equality and