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.


Reply via email to