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);
select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 10, 1);
--select * from pgest2('{foo}') as (a text, b text) ;
--select * from pgest2('{foo}') as (a text, b text, c text) ;
--select * from pgest2('{foo}') as (a text, b text, c text, d text) ;

-- 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('/home/dpavlin/pgestraier/data/casket', 'blade runner', 'year NUMGT 1990', null, null) group by title order by title;
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	select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 10, 1);
7	--select * from pgest2('{foo}') as (a text, b text) ;
8	--select * from pgest2('{foo}') as (a text, b text, c text) ;
9	--select * from pgest2('{foo}') as (a text, b text, c text, d text) ;
10
11	-- find all references to blade runner in other films
12	select * from pgest('##dir##/data/casket','blade runner', '@title !ISTRINC blade runner', null, null) ;
13
14	-- find all references and count them to blade runner after 1990
15	select count(title),title from pgest('/home/dpavlin/pgestraier/data/casket', 'blade runner', 'year NUMGT 1990', null, null) group by title order by title;