Re: [Refdb-devel] parentheses in keywords

[rob c. <ro...@st...>]

> getref ":KW:='10102-43-9 (Nitric Oxide)'"
> 
> works like a charm. The trick is to employ the double quotes to hide
> the single quotes from the query parser. This way they'll be left
> alone until the SQL tokenizer works on the actual query.

i bet this works with sqlite...i'll have to give it a try, but the RLIKE
still wants the parentheses quoted in mysql according to the logs...

i'll try to test postgresql later tonight, if i get the chance...

staying db-agnostic is often a pain, but i'm glad you're doing it....