/[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 19 by dpavlin, Thu May 26 17:56:53 2005 UTC
# Line 10  CREATE TYPE __pgest AS ( Line 10  CREATE TYPE __pgest AS (
10  );  );
11    
12  -- Search est-e index as table  -- Search est-e index as table
13  -- select * from pgest('/index/path/','query', '@uri ISTREW .txt' limit, offset);  -- select * from pgest('/index/path','query', '@uri ISTREW .txt', limit, offset);
14  CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int)  CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int)
15          RETURNS SETOF __pgest          RETURNS SETOF __pgest
16          AS 'pgest', 'pgest'          AS 'pgest', 'pgest'
17          LANGUAGE C IMMUTABLE CALLED ON NULL INPUT;          LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
18    
19  CREATE OR REPLACE FUNCTION pgest2(text[])  -- select * from pgest('/index/path', 'query', '@title ISTRINC foo', limit, offset, {'@id','@title','@size'}) as (id text, title text, size text);
20  RETURNS setof record  CREATE OR REPLACE FUNCTION pgest(text, text, text, int, int, text[])
21  AS 'pgest','pgest2'          RETURNS setof record
22  LANGUAGE 'C' IMMUTABLE STRICT;          AS 'pgest','pgest_attr'
23            LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
Legend:
Removed from v.12  
changed lines
  Added in v.19
  ViewVC Help
Powered by ViewVC 1.1.26