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

Annotation of /trunk/pgest.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 31 - (hide 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 dpavlin 1
2 dpavlin 31 -- 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 dpavlin 19 RETURNS setof record
5     AS 'pgest','pgest_attr'
6     LANGUAGE 'C' IMMUTABLE CALLED ON NULL INPUT;
7 dpavlin 25

  ViewVC Help
Powered by ViewVC 1.1.26