Import { my_view } from ‘../db/schema.ts’
db.select({
Id: my_view.id
col1: my_view.col1,
col2: my_view.col2,
col1_sml: sql`similarity( col1, ${val1 || “”} )` ,
col2_sml: sql`similarity( col1, ${val1 || “”} )` ,
})
.from(my_view)
.where(sql`${my_view.col1} % ${val1 || “”} OR ${my_view.col2} % ${ val2 || “”}`)
.orderBy( ({ col1_sml }) => desc(col1_sml), ({col2_sml}) => desc(col2_sml) )
.limit(n)
Import { my_view } from ‘../db/schema.ts’
db.select({
Id: my_view.id
col1: my_view.col1,
col2: my_view.col2,
col1_sml: sql`similarity( col1, ${val1 || “”} )` ,
col2_sml: sql`similarity( col1, ${val1 || “”} )` ,
})
.from(my_view)
.where(sql`${my_view.col1} % ${val1 || “”} OR ${my_view.col2} % ${ val2 || “”}`)
.orderBy( ({ col1_sml }) => desc(col1_sml), ({col2_sml}) => desc(col2_sml) )
.limit(n)