Alain Roger escribió: > IF (outResult = 1) THEN > > return true; > > ELSE > > EXECUTE 'create table sw.tmp_import (id serial NOT NULL CONSTRAINT id_key > > PRIMARY KEY, software VARCHAR(1024), barcode VARCHAR(10), username > > VARCHAR(1024), area VARCHAR(512), locality VARCHAR(512)) WITH > > (OIDS=FALSE);'; > > EXECUTE 'ALTER TABLE sw.tmp_import OWNER TO usr_audit'; > > return false; > > END IF;
Just leave out the EXECUTE and quotes. This example should work without them. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
