Re: [SQL] returning values to variables from dynamic SQL

2012-09-08 Thread David Johnston
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of James Sharrett Sent: Saturday, September 08, 2012 6:24 PM To: pgsql-

[SQL] returning values to variables from dynamic SQL

2012-09-08 Thread James Sharrett
I have a PG function ( using plpgsql) that calls a number of sub functions also in plpgsql. I have two main problems that seem to be variations on the same theme of running dynamic SQL from a variable with the EXECUTE statement and returning the results back to a variable defined in the calling fu