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/