/[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 19 by dpavlin, Thu May 26 17:56:53 2005 UTC revision 25 by dpavlin, Fri May 27 21:06:01 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', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
 --      id integer,  
         id text,  
         uri text,  
         title text,  
 --      size integer  
         size text  
 );  
   
 -- Search est-e index as table  
 -- select * from pgest('/index/path','query', '@uri ISTREW .txt', limit, offset);  
 CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int)  
         RETURNS SETOF __pgest  
         AS 'pgest', 'pgest'  
         LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;  
   
 -- select * from pgest('/index/path', 'query', '@title ISTRINC foo', limit, offset, {'@id','@title','@size'}) as (id text, title text, size text);  
3  CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int, text[])  CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int, text[])
4          RETURNS setof record          RETURNS setof record
5          AS 'pgest','pgest_attr'          AS 'pgest','pgest_attr'
6          LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;          LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
7    
Legend:
Removed from v.19  
changed lines
  Added in v.25
  ViewVC Help
Powered by ViewVC 1.1.26