On Wed, Mar 9, 2011 at 2:08 PM, Samuel Gendler <sgend...@ideasculptor.com> wrote: > when I run 'select 1count(*) from table' in my postgres 8.4 installation, I > get the exact same error message. Assuming the '1count()' function does > exist, perhaps you need to full qualify it with a schema name? > It looks to me like the query you are passing to the procedure is invalid > and is generating the error. Perhaps the 1 in front of count(*) is a typo?
Also seem to be missing "p_id" from your execute statement: execute 'create table result_'|| p_id ||' as '||p_sql; -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
