SQL 2016 MATCH RECOGNIZE JDBC parameter Marker / Escape Characters

[Mark Rotteveel]

On 9-10-2018 13:43, Lance Andersen wrote:
> 
>> On Oct 9, 2018, at 7:22 AM, Dave Cramer <davecramer at gmail.com> wrote:
>>
>> PostgreSQL has a related problem in that ? is actually an operator for hstore, so in some cases we needed to allow ? to not be used ad a parameter marker. We solved it by using double question marks ?? to denote the hstore operator.
>>
>> Obviously I'd love to see this solution get in the spec.
>>
>> FWIW I find the {\..\} to be verbose..
> 
> Do you have an alternative suggestion?  That issue had been raised previously when it was discussed but the discussion did not come to a conclusion

See my other post, I think {`..`} might be a good alternative. It 
doesn't require escaping in normal strings nor in JEP-326 raw string 
literals (where you just need to double the back-ticks around the string).

Mark
-- 
Mark Rotteveel