/[pgestraier]/trunk/test.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/test.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 48 by dpavlin, Sat Sep 10 20:35:09 2005 UTC revision 49 by dpavlin, Sat Oct 29 18:54:40 2005 UTC
# Line 21  select title from pgest('##dir##/data/ca Line 21  select title from pgest('##dir##/data/ca
21    
22  -- node API examples  -- node API examples
23    
24  select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text);  select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 1, 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text);
25    
26  -- comparison of direct access and node API  -- comparison of direct access and node API
27    
28  explain analyze select title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text);  explain analyze select title from pgest('##dir##/data/casket', 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text);
29  explain analyze select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text);  explain analyze select title from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', 0, 'blade runner', 'year NUMGT 1990', '@title STRA', 5, 0, array['@title']) as (title text);
Legend:
Removed from v.48  
changed lines
  Added in v.49
  ViewVC Help
Powered by ViewVC 1.1.26