pgestraier/trunk/test.sql

--select * from pgest(null, 'a OR b OR c', '', 0, 0);
--select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 0, 10);
--select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 20, 0);
--select * from pgest('##dir##/data/casket', 'a OR b OR c', null, 20, 0);
--select * from pgest('##dir##/data/casket', 'a OR b OR c', '@uri ISTREW .txt', 100, 0);

-- find all references to blade runner in other films
select * from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null) ;

-- find all references and count them to blade runner after 1990
select count(title),title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', null, null) group by title order by title;

-- example of new API which allows user to specify attributes
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;

1	--select * from pgest(null, 'a OR b OR c', '', 0, 0);
2	--select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 0, 10);
3	--select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 20, 0);
4	--select * from pgest('##dir##/data/casket', 'a OR b OR c', null, 20, 0);
5	--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
8	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
11	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
14	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