On Saturday, April 25, 2020 at 9:01:27 AM UTC-7, Dennis O'Connell wrote:
>
> Hi Jeremy,
>
> Thanks for the tip. But the thing is if I do that, ".*#{query}.*" becomes
> '.*#{query}.*'. Single quote instead of double quote. This is not a valid
> SQL. It should be double quoted.
>
> I will try to figure it out but let me know if you have any recommendation
> for double quote.
>
You can use Sequel.identifier(".*#{query}.*") to treat it as an identifier
(double quotes) instead of string (single quotes).
What I find most peculiar about this discussion is you said you are using
PostgreSQL 12.2 in the other thread, and PostgreSQL's documentation
explicitly states XQuery/like_regex is not supported:
https://www.postgresql.org/docs/12/functions-matching.html (see 9.7.3.8).
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/dda4a2bf-2e15-4939-bf2a-4b7a4c3735e0%40googlegroups.com.
