adding suports for where table.field === 'query'::simple::text[]::boost(2)

[Pandaaaa906]

What feature are you requesting?

i want to perform boost when searching

select
from table
where table.field === 'query'::simple::text[]::boost(2)

Why are you requesting this feature?

when i do

stmt.where(search.term(Table.field, 'query', tokenizer='simple', boost=2))

the sql will get

...
where table.field === 'query'::simple::boost(2)

it will thow somethiing like

ERROR:  cannot cast type pdb.simple to pdb.boost

it sure i can do something like

search.term(
Table.field,
Cast(search.PDBCast('query', "simple"), ARRAY(Text)),
boost=2.0
)

so i wonder if it could support directly

What is your proposed implementation for this feature?

No response

[isaacvando]

Thanks for the issue! This is actually a bug in ParadeDB itself; where table.field === 'query'::simple::boost(2) should be allowed without casting to text[]. We have an issue tracking it here paradedb/paradedb#4430