1 |
select * from pgest(null, 'a OR b OR c', '', 0, 0); |
select * from pgest(null, 'a OR b OR c', '', 0, 0); |
2 |
select * from pgest('##dir##/data/casket', 'a OR b OR c', '', 0, 0); |
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); |
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); |
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); |
select * from pgest('##dir##/data/casket', 'a OR b OR c', '@uri ISTREW .txt', 100, 0); |
7 |
--select * from pgest2('{foo}') as (a text, b text) ; |
--select * from pgest2('{foo}') as (a text, b text) ; |
8 |
--select * from pgest2('{foo}') as (a text, b text, c text) ; |
--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) ; |
--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) ; |