I am able to run the query successfully outside of the function. I know the
problem is with, per_inventory_query:= quote_literal((select
A.company_name from
fetch_cucm_systems()
where A.id=sys_id ::bigint)) ;
I was hoping somebody could eyeball the syntax and tell me why select * from
bar()
becomes select quote_literal((select
A.company_name from
fetch_cucm_systems()
where A.id=sys_id ::bigint)) in my case ?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Need-help-with-this-Function-I-m-getting-an-error-tp5806884p5806892.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.