Re: Need help with this Function. I'm getting an error - Mailing list pgsql-novice

From ssharma
Subject Re: Need help with this Function. I'm getting an error
Date
Msg-id 1402523132537-5806892.post@n5.nabble.com
Whole thread Raw
In response to Re: Need help with this Function. I'm getting an error  (David G Johnston <david.g.johnston@gmail.com>)
Responses Re: Need help with this Function. I'm getting an error  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-novice
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.


pgsql-novice by date:

Previous
From: Markus Neumann
Date:
Subject: Re: I probably don't understand aggregates.
Next
From: Markus Neumann
Date:
Subject: Re: I probably don't understand aggregates.