Advertisement
Guest User

apostrophes eg

a guest
Jun 29th, 2016
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.33 KB | None | 0 0
  1. evergreen=# select * from metabib.title_field_entry where source = 1178516;
  2. id | source | field | value | index_vector
  3. ----------+---------+-------+------------------------------+-----------------------------------------------------------------------------------------
  4. 21695600 | 1178516 | 4 | All these things I have done | 'all':1A,7C 'done':6A,12C 'have':5A,11C 'i':4A,10C 'these':2A,8C 'thing':9C 'things':3A
  5. 21695599 | 1178516 | 6 | All these things I've done | 'all':1A,7C 'done':6A,12C 'i':4A,10C 'these':2A,8C 'thing':9C 'things':3A 've':5A,11C
  6. (2 rows)
  7.  
  8. evergreen=# select * from config.metabib_field_index_norm_map where field in (4,6);
  9. id | field | norm | params | pos
  10. ----+-------+------+----------+-----
  11. 8 | 4 | 2 | | 0
  12. 12 | 6 | 2 | | 0
  13. 7 | 4 | 22 | | 0
  14. 11 | 6 | 22 | | 0
  15. 64 | 6 | 12 | ["/",""] | -2
  16.  
  17. evergreen=# select id,name,func from config.index_normalizer where id in (2,12,22);
  18. id | name | func
  19. ----+----------------------+------------------
  20. 2 | Normalize date range | split_date_range
  21. 12 | Replace | replace
  22. 22 | Search Normalize | search_normalize
  23. (3 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement