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

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

revision 9 by dpavlin, Sat Feb 19 00:59:08 2005 UTC revision 22 by dpavlin, Sun May 29 22:41:20 2005 UTC
# Line 1  Line 1 
1  drop type __pgswish cascade;  drop type __pgswish cascade;
2    
3  CREATE TYPE __pgswish AS (  CREATE TYPE __pgswish AS (
4          rank int,          rank integer,
5          path text,          path text,
6          headline text,          headline text,
7          size int,          size integer
         properties text[]  
8  );  );
9    
10  --                         pgswish('/index/path/','query', 'property' 'sort');  -- Search swish-e index as table
11  CREATE OR REPLACE FUNCTION pgswish(text, text, text, text)  -- select * from pgswish('/index/path/','query', 'sort');
12    CREATE OR REPLACE FUNCTION pgswish(text, text, text)
13          RETURNS SETOF __pgswish          RETURNS SETOF __pgswish
14          AS 'pgswish', 'pgswish'          AS 'pgswish', 'pgswish'
15          LANGUAGE C IMMUTABLE STRICT;          LANGUAGE C IMMUTABLE STRICT;
16    
17    -- select * from pgswish_arr('/index/path', 'query', 'placeholder', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
18    CREATE OR REPLACE FUNCTION pgswish(text, text, text, int, int, text[])
19            RETURNS setof record
20            AS 'pgswish','pgswish_arr'
21            LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
Legend:
Removed from v.9  
changed lines
  Added in v.22
  ViewVC Help
Powered by ViewVC 1.1.26