8 |
select * from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null) ; |
select * from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null) ; |
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('/home/dpavlin/pgestraier/data/casket', 'blade runner', 'year NUMGT 1990', null, null) group by title order by title; |
select count(title),title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', null, null) group by title order by title; |
12 |
|
|
13 |
-- example of new API which allows user to specify attributes |
-- example of new API which allows user to specify attributes |
14 |
select * from pgest('##dir##/data/casket', 'blade runner', null, 10, null, array['@id','@title','year']) as (id text, title text, year text) ; |
select count(title),year from pgest('##dir##/data/casket', 'blade runner', null, null, null, array['@title','year']) as (title text, year text) group by year order by year asc; |
15 |
|
|