Re: EXECUTE problem on schema - Mailing list pgsql-sql

From jack
Subject Re: EXECUTE problem on schema
Date
Msg-id 004501c2f4c5$5116f970$1400a8c0@jac
Whole thread Raw
In response to EXECUTE problem on schema  ("jack" <datactrl@tpg.com.au>)
Responses Re: EXECUTE problem on schema  (Ian Barwick <barwick@gmx.net>)
List pgsql-sql
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';



pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Off topic : world database
Next
From: "dailiming"
Date:
Subject: How to configure two netcard for PostgreSQL?