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

Contents of /trunk/pgest.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 31 - (show annotations)
Wed Jul 6 14:47:56 2005 UTC (18 years, 9 months ago) by dpavlin
File size: 337 byte(s)
added results order (see test.sql for example) to function arguments,
fixed limit (it really returns limit rows, and not limit - offset :-\),
added est_cond_delete(cond) so that we don't leek memory

1
2 -- select * from pgest('/index/path', 'query', '@title ISTRINC foo', '@title STRA', limit, offset, ARRAY['@id','@title','@size']) as (id text, title text, size text);
3 CREATE OR REPLACE FUNCTION pgest(text, text, text, text, int, int, text[])
4 RETURNS setof record
5 AS 'pgest','pgest_attr'
6 LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
7

  ViewVC Help
Powered by ViewVC 1.1.26