/[pgestraier]/trunk/pgest.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/pgest.sql

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

revision 12 by dpavlin, Wed May 25 23:38:37 2005 UTC revision 49 by dpavlin, Sat Oct 29 18:54:40 2005 UTC
# Line 1  Line 1 
 drop type __pgest cascade;  
1    
2  CREATE TYPE __pgest AS (  -- select * from pgest('/index/path', 'query', '@title ISTRINC foo', '@title STRA', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
3  --      id integer,  CREATE OR REPLACE FUNCTION pgest(text, text, text, text, int, int, text[])
4          id text,          RETURNS setof record
5          uri text,          AS 'pgest','pgest_attr'
6          title text,          LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
 --      size integer  
         size text  
 );  
7    
8  -- Search est-e index as table  -- select * from pgest('http://localhost:1978/node/trivia', 'admin', 'admin', depth, 'query', '@title ISTRINC foo', '@title STRA', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
9  -- select * from pgest('/index/path/','query', '@uri ISTREW .txt' limit, offset);  CREATE OR REPLACE FUNCTION pgest(text, text, text, int, text, text, text, int, int, text[])
10  CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int)          RETURNS setof record
11          RETURNS SETOF __pgest          AS 'pgest','pgest_node'
12          AS 'pgest', 'pgest'          LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
         LANGUAGE C IMMUTABLE CALLED ON NULL INPUT;  
   
 CREATE OR REPLACE FUNCTION pgest2(text[])  
 RETURNS setof record  
 AS 'pgest','pgest2'  
 LANGUAGE 'C' IMMUTABLE STRICT;  
Legend:
Removed from v.12  
changed lines
  Added in v.49
  ViewVC Help
Powered by ViewVC 1.1.26