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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.