[SR-Users] Parser error with sql_pvquery?

[Alex Balashov]

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.

-- 
Alex Balashov - Principal
Evariste Systems LLC
303 Perimeter Center North
Suite 300
Atlanta, GA 30346
United States

Tel: +1-678-954-0670
Web: http://www.evaristesys.com/