1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
SELECT
word.*,
paragraph.id AS paragraph_id
FROM word
INNER JOIN paragraph ON paragraph.page_id = word.page_id
WHERE
word.character_range @> paragraph.character_range
AND word.character_range <@ paragraph.character_range
AND word.character_range && paragraph.character_range
AND word.character_range << paragraph.character_range
AND word.character_range >> paragraph.character_range
AND word.character_range &> paragraph.character_range
AND word.character_range &< paragraph.character_range
AND word.character_range -|- paragraph.character_range
AND word.character_range + paragraph.character_range
AND word.character_range * paragraph.character_range
AND word.character_range - paragraph.character_range
|
