/[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 1 by dpavlin, Fri May 20 12:19:05 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);
3  --      id integer,  CREATE OR REPLACE FUNCTION pgest(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    
 -- Search est-e index as table  
 -- select * from pgest('/index/path/','query', 'sort');  
 CREATE OR REPLACE FUNCTION pgest(text, text, text)  
         RETURNS SETOF __pgest  
         AS 'pgest', 'pgest'  
         LANGUAGE C IMMUTABLE STRICT;  
   
 CREATE OR REPLACE FUNCTION pgest2(text[])  
 RETURNS setof record  
 AS 'pgest','pgest2'  
 LANGUAGE 'C' IMMUTABLE STRICT;  
Legend:
Removed from v.1  
changed lines
  Added in v.25
  ViewVC Help
Powered by ViewVC 1.1.26