--- trunk/test.sql	2005/05/20 12:19:05	1
+++ trunk/test.sql	2005/05/26 20:22:44	23
@@ -1,5 +1,15 @@
-select * from pgest('##dir##/casket', 'a OR b OR c', '' ) ;
-select * from pgest('##dir##/casket', 'c*', 'estrank');
---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) ;
+--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##/pgestraier/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;
+