I want to query both value route and is_deleted. This is the query i come up with
select *
from route r
where (r.route, r.is_deleted) = any(string_to_array('ABBEYARD, VICTORIA, AUSTRALIA (CBR), false',';'));
But i got error
SQL Error [42883]: ERROR: operator does not exist: record = text
Hint: No operator matches the given name and argument type(s). You might need to add
explicit type casts.
Position: 53
can anyone enlighten me with a proper operator?