On 01/12/2012 19:11, Peter Kroon wrote: > How can I achieve this? > > EXECUTE ' > > if 1=1 then > raise notice ''%'', ''notice has been raised...''; > end if; > > ';
I think EXECUTE used like this is available only in a function:
create or replace function my_function() returns void as $$ begin execute .... end; $$ language plpgsql;
In "ordinary" SQL, EXECUTE executes a prepared statement.
Ray.
-- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie