Re: EXECUTE problem on schema

From: "jack" <datactrl(at)tpg(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>, "Ian Barwick" <barwick(at)gmx(dot)net>
Subject: Re: EXECUTE problem on schema
Date: 2003-03-28 00:59:40
Message-ID: 004501c2f4c5$5116f970$1400a8c0@jac
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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';

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message dailiming 2003-03-28 02:35:52 How to configure two netcard for PostgreSQL?
Previous Message Bruno Wolff III 2003-03-27 17:05:36 Re: Off topic : world database