Re: [SR-Users] Parser error with sql_pvquery?

On 03/11/2015 07:12 PM, Anthony Messina wrote:

On Wednesday, March 11, 2015 06:08:04 PM Anthony Messina wrote:

...

Is this query "too complex" for the parser, or is there something I've missed above?

Thanks. -A

Nevermind... I was missing a '}' earlier in the script :( Sorry for the noise. -A

:-)

Just for information's sake, sql_pvquery() does not parse the SQL query and does not care what is in there, syntactically. The query string is not analysed or mediated by Kamailio's DB API layer or anything of the sort. It's simply passed along directly to Postgres, as-is. So, if there's an issue with the query itself, the error would be returned from Postgres, rather than expressed as a Kamailio runtime syntax error.