Received: from bleys.tpgi.com.au (bleys.tpgi.com.au [203.12.160.38]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2N9Fww15475 for ; Fri, 23 Mar 2001 04:16:03 -0500 (EST) (envelope-from quals@bigfoot.com) Received: (from smtpd@localhost) by bleys.tpgi.com.au (8.11.2/8.11.2) id f2N9E6t02870 for ; Fri, 23 Mar 2001 20:14:06 +1100 Received: from bri2-56k-153.tpgi.com.au(203.29.144.153), claiming to be "hnjack" via SMTP by bleys.tpgi.com.au, id smtpdTDN5bN; Fri Mar 23 20:13:50 2001 Message-ID: <004f01c0b379$19c48c60$2400a8c0@hnjack> From: "datactrl" To: Subject: SOME PL/PGSQL PROBLEMS Date: Fri, 23 Mar 2001 19:10:16 +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 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200103/457 X-Sequence-Number: 2125 I found there are some problems with PL/pgSQL. 1) 'Drop Table' doesn't work at all 2) '--' comment causes parsing error 3) Execute doesn't work at all. It always causes parsing error! Some questions 1) Can I use variable in FROM clause for a table name? 2) Can I use variable in WHERE such as xxx = variable? JACK