PG has operators with ? in them (e.g., ?|) because, well, of course it does.
So there's a "conflict" between SQL placeholders (?) and PG operators and you need to escape the question mark by doubling it to get the operator ??| instead of a placeholder.
PG has operators with
?
in them (e.g.,?|
) because, well, of course it does.So there's a "conflict" between SQL placeholders (
?
) and PG operators and you need to escape the question mark by doubling it to get the operator??|
instead of a placeholder.