Ian,
Sorry about the version mistake. It's V7.3.2. And the following are the
example.
Jack
CREATE TABLE test_j2(c1 varchar (2),n2 integer,
PRIMARY KEY(c1, n2)
);
/*
a1 100
b1 200
*/
/*
Calling tesp_test1 with 'test_j2' is ok, while calling with 'public.test_j2'
will fail.
*/
CREATE OR REPLACE FUNCTION tesP_test1( NAME) RETURNS INTEGER AS'
BEGIN
EXECUTE ''UPDATE ''||quote_ident($1)||'' SET n2 = 1'';RETURN 0;
END;'LANGUAGE 'PLPGSQL';