About EXECUTE in pl/pgsql

From: "jack" <datactrl(at)tpg(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: About EXECUTE in pl/pgsql
Date: 2002-03-25 03:42:22
Message-ID: 003401c1d3af$17bf8710$1400a8c0@jac
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
I do following in pl/pgsql. (st1 has been set to "LIKE 'abc%' ")

EXECUTE
''CREATE TEMP TABLE comuser AS '' ||
''SELECT * FROM comt_user1 WHERE username ''||St1||
''ORDER BY username;'';

I've got "ERROR: EXECUTE ..SELECT INTO hasn't impletmented", How can??

JACK

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-03-25 03:54:14 Re: About temporary table
Previous Message jack 2002-03-25 03:37:35 About temporary table