5 |
--select * from pgest('##dir##/data/casket', 'a OR b OR c', '@uri ISTREW .txt', 100, 0); |
--select * from pgest('##dir##/data/casket', 'a OR b OR c', '@uri ISTREW .txt', 100, 0); |
6 |
|
|
7 |
-- find all references to blade runner in other films |
-- find all references to blade runner in other films |
8 |
select substr(uri,45),title,year from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null, null, array['@uri','@title','year']) as (uri text, title text, year int); |
select uri,title,year from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null, null, array['@uri','@title','year']) as (uri text, title text, year int); |
9 |
|
|
10 |
-- find all references and count them to blade runner after 1990 |
-- find all references and count them to blade runner after 1990 |
11 |
select count(title),title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', null, null, null, array['@title']) as (title text) group by title order by title; |
select count(title),title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', null, null, null, array['@title']) as (title text) group by title order by title; |