Betsy,
> The variable is defined as TEXT, and I'm trying to pass it to a function
> that is setup to accept a TEXT parameter. Here is the call:
First off, let me say that you may be better off using a different strategy
for this. But I don't know much about your application, so you may not.
> FOR getpercentiles IN EXECUTE ''SELECT * FROM
> get_facility_percentiles(''||wagerateid_list||'')'' LOOP -- RAISE
> NOTICE ''DONE CALLING FUNCTION '';
Aha, syntax error, you forgot the nested quotes:
FOR getpercentiles IN EXECUTE ''SELECT * FROM get_facility_percentiles(''''''
|| wagerateid_list || '''''')'' LOOP
FWIW, version 8.0 will have a feature to do away with the nested-quote-mania.
--
Josh Berkus
Aglio Database Solutions
San Francisco
