/[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 16 by dpavlin, Sun Feb 20 21:51:56 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    CREATE OR REPLACE FUNCTION pgswish2(text[])
18    RETURNS setof record
19    AS 'pgswish','pgswish2'
20    LANGUAGE 'C' IMMUTABLE STRICT;
Legend:
Removed from v.9  
changed lines
  Added in v.16
  ViewVC Help
Powered by ViewVC 1.1.26