Hi Mike !
Here is the function :
create or repl...
# javascriptp
Pierre Debruyne
10/15/2021, 3:27 PMHi Mike !
Here is the function :
create or replace function search_posts(keyword text)
returns table(vehicules record)
as
$func$
select
*
from
vehicules
where
to_tsvector(constructeur || ' ' || nom_propulsion || ' ' || nom) -- concat columns, but be sure to include a space to separate them!
@@ to_tsquery(keyword);
$func$
language sql;
when i run the SQL command i get a success response
g
garyaustin
10/15/2021, 4:10 PMUsually when I have hit that it is because the parameters calling don't exactly match those defined in the function. It is considered a different function if number or type of parameters is different
p
Pierre Debruyne
10/15/2021, 5:13 PMok i'll try to type it then 🙂
Pierre Debruyne
10/15/2021, 5:14 PMThanks, i'll let you know
Pierre Debruyne
10/15/2021, 5:20 PMHi tried with a type varchar and text, but it's the same response.
And i'm sure that i pass a string as you can see 🙂
const getVehicules = async (input: String) => {
let { data, error } = await supabase.rpc('search_posts', {
input
});
console.error(error);
console.log(data);
};
getVehicules('berlingo');
m
mikebarkmin
10/15/2021, 5:59 PMYou need to use keyword instead of input
mikebarkmin
10/15/2021, 5:59 PMThe function parameters need to be map by name.
p
Pierre Debruyne
10/18/2021, 8:16 AMYes i changed from input to keyword and i don't have this error anymore. but i have a new one now 😄
a column definition list is required for functions returning "record"
How come is it so hard to do a simple text search on 2 columns ! 😄