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