Thanks massimo, worked for me.
On 22 Sep., 15:28, mdipierro <[email protected]> wrote: > No but assuming you have done this: > > 1. ALTER TABLE blog_entry ADD COLUMN body_tsv tsvector; > 2. CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE ON > blog_entry > FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(body_tsv, > 'pg_catalog.english', body); > 3.CREATE INDEX blog_entry_tsv ON blog_entry USING gin(body_tsv); > > You can write this: > > 4. SELECT title FROM blog_entry WHERE body_tsv @@ plainto_tsquery > ('hello world'); > > as > > db("body_tsv @@ plainto_tsquery('hello world')").select > (db.blog_entry.title) > > I have not tried it but it should work. > > Massimo > > On Sep 22, 4:34 am, max <[email protected]> wrote: > > > I have created a full text index on a postgres database. > > Is there any web2py type search syntax for tsvector search without > > using the sql syntax? > > > This is a example way how i create the fulltext index. > > > 1. ALTER TABLE blog_entry ADD COLUMN body_tsv tsvector; > > 2. CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE ON > > blog_entry > > FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(body_tsv, > > 'pg_catalog.english', body); > > 3.CREATE INDEX blog_entry_tsv ON blog_entry USING gin(body_tsv); > > 4. SELECT title FROM blog_entry WHERE body_tsv @@ plainto_tsquery > > ('hello world'); --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
