Received: from mail2.tpgi.com.au (mail.tpgi.com.au [203.12.160.58]) by postgresql.org (Postfix) with ESMTP id 3108F475451 for ; Sun, 24 Mar 2002 22:42:28 -0500 (EST) Received: from jac (bri4-56k-247.tpgi.com.au [202.7.185.247]) by mail2.tpgi.com.au (8.11.6/8.11.6) with SMTP id g2P3gV717455 for ; Mon, 25 Mar 2002 14:42:31 +1100 Message-ID: <003401c1d3af$17bf8710$1400a8c0@jac> From: "jack" To: Subject: About EXECUTE in pl/pgsql Date: Mon, 25 Mar 2002 13:42:22 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200203/299 X-Sequence-Number: 7178 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