Error code 42725

{
code: '42725',
details: null,
hint: 'Could not choose a best candidate operator. You might need to add explicit type casts.',
message: 'operator is not unique: text <@ unknown'
}
This is what supabase returned when I called containedBy method. I have no idea what is it mean so can anybody can help me? Thanks in advance.

this is my code line:

const { data, error, count } = await supabaseClient
    .from("profile")
    .select("id,email,username,role,telephone,name,start_shift,end_shift", {
      count: "exact",
    })
    .containedBy("role", ["admin", "employee"])
    .range(rangeArray[0], rangeArray[1]);

const { data, error, count } = await supabaseClient
    .from("profile")
    .select("id,email,username,role,telephone,name,start_shift,end_shift", {
      count: "exact",
    })
    .containedBy("role", ["admin", "employee"])
    .range(rangeArray[0], rangeArray[1]);

Supabase•4y ago•

3 replies

usamichizuru

Error code 42725

const { data, error, count } = await supabaseClient
    .from("profile")
    .select("id,email,username,role,telephone,name,start_shift,end_shift", {
      count: "exact",
    })
    .containedBy("role", ["admin", "employee"])
    .range(rangeArray[0], rangeArray[1]);

const { data, error, count } = await supabaseClient
    .from("profile")
    .select("id,email,username,role,telephone,name,start_shift,end_shift", {
      count: "exact",
    })
    .containedBy("role", ["admin", "employee"])
    .range(rangeArray[0], rangeArray[1]);

Error code 42725

Similar Threads

Error code 42725

Similar Threads

Similar Threads

Similar Threads