Received: from mailserv.hub.org (mailserv.hub.org [216.126.84.253]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA2DH8q08860 for ; Fri, 2 Nov 2001 08:17:08 -0500 (EST) (envelope-from jason@newhonest.com) Received: from mail.newhonest.com (IDENT:root@vp239045.uac62.hknet.com [202.71.239.45]) by mailserv.hub.org (8.11.4/8.11.4) with ESMTP id fA26x3f12742 for ; Fri, 2 Nov 2001 01:59:14 -0500 (EST) (envelope-from jason@newhonest.com) Received: from jason (jason.newhonest.com [192.168.1.2]) by mail.newhonest.com (8.11.2/8.11.2) with SMTP id fA271B427727 for ; Fri, 2 Nov 2001 15:01:11 +0800 Message-ID: <000e01c1636b$c466b380$0201a8c0@newhonest.com> From: "Jason Kwok" To: Subject: select from a dynamic table name Date: Fri, 2 Nov 2001 14:58:24 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="big5" 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: 200111/46 X-Sequence-Number: 5431 Since I could return a rowset (some records) from a function of pgsql or plpgsql, I saved all the records into a temp file. Then I want to get the rowset by another select statement from this temp table with dynamic name, could I do something like the folowing : select * from a_dynamic_table_name ? If the a_dynamic_table_name could be specified as a function, it would be great, because inside the function I could insert the needed rows into the temp file and then return its name for the select statement. Is this possible? == ==== Best Regards Jason Kwok ============== ==== --- Virus Free Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.292 / Virus Database: 157 - Release Date: 2001/10/26