In psql I can do: select * from isi.rauthor A where A.addressfulltext@@'south & africa'
but the following l = db("rauthor.addressfulltext@@'south & africa'").select() results in TypeError: %d format: a number is required, not NoneType Why? Model: from gluon.dal import SQLCustomType tsv = SQLCustomType( type ='text', native='tsvector' ) ... Field('addressfulltext',type=tsv), Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.