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