--- trunk/test.sql 2005/05/26 13:57:32 17 +++ trunk/test.sql 2005/05/26 17:56:53 19 @@ -1,15 +1,15 @@ -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) ; +--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('/home/dpavlin/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 * from pgest('##dir##/data/casket', 'blade runner', null, 10, null, array['@id','@title','year']) as (id text, title text, year text) ; +