Jim Fulton

I got bitten by this today. I had to capitalize both "create" and "table". It's really surprising to me that parsing is so affected by case.

Thanks! Some results and a little commentary. I'll follow on with a summary comment. So, the original query: SELECT docid, (text_vector to_tsquery('english', 'europe')) / coefficient as rank, count(*) over() FROM...

So some questions/comments: - Should prefix queries work in ``ORDER BY`` with RUM? - Should counts match? (I might be willing to trade off count accuracy for speed. :) )...

On Wed, Mar 1, 2017 at 7:00 PM, Oleg Bartunov wrote: > Have you seen faceted search example > http://akorotkov.github.io/blog/2016/06/17/faceted-search/ No, but as I said, that (window functions) is how...

On Thu, Mar 2, 2017 at 4:59 AM, Arthur wrote: > Should counts match? (I might be willing to trade off count accuracy for > speed. :) ) > Yes,...

Should a prefix search (like ``text_vector to_tsquery('english', 'euro:*')``) work? Currently, it errors (and poisons the session) for me.

On Thu, Mar 2, 2017 at 11:26 AM, Arthur wrote: > Yep. It should work. I work on fixing it. It is the bug too. > Cool. Thanks! Should counts...

I implemented faceted search using GIN/ts_rank_cd: SELECT * from ( SELECT content_type, docid, row_number() over ( PARTITION BY content_type ORDER BY ts_rank_cd(text_vector, to_tsquery('english', 'open')) desc ) AS rank, count(*) over...

Nope. That didn't compile. Unknown column ``counters``. Maybe you meant: EXPLAIN ANALYZE with items as ( SELECT content_type, docid, row_number() over ( PARTITION BY content_type ORDER BY text_vector to_tsquery('english', 'open')...

Sure. I'll test it soon.