/[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

Annotation of /trunk/pgswish.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 16 - (hide annotations)
Sun Feb 20 21:51:56 2005 UTC (19 years, 2 months ago) by dpavlin
File size: 463 byte(s)
a try to implement function which returns record (pgswish2)

1 dpavlin 8 drop type __pgswish cascade;
2    
3     CREATE TYPE __pgswish AS (
4 dpavlin 13 rank integer,
5 dpavlin 8 path text,
6     headline text,
7 dpavlin 13 size integer
8 dpavlin 8 );
9    
10 dpavlin 14 -- Search swish-e index as table
11     -- select * from pgswish('/index/path/','query', 'sort');
12     CREATE OR REPLACE FUNCTION pgswish(text, text, text)
13 dpavlin 8 RETURNS SETOF __pgswish
14     AS 'pgswish', 'pgswish'
15     LANGUAGE C IMMUTABLE STRICT;
16    
17 dpavlin 16 CREATE OR REPLACE FUNCTION pgswish2(text[])
18     RETURNS setof record
19     AS 'pgswish','pgswish2'
20     LANGUAGE 'C' IMMUTABLE STRICT;

  ViewVC Help
Powered by ViewVC 1.1.26