Received: from cmet.net ([216.72.177.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e8MM4qs90805; Fri, 22 Sep 2000 18:04:52 -0400 (EDT) Received: from cmet.net (root@[216.72.176.22]) by cmet.net (8.8.5/8.8.5) with ESMTP id SAA27859; Fri, 22 Sep 2000 18:00:12 -0400 (CST) Message-ID: <39CBD883.9A63F0C6@cmet.net> Date: Fri, 22 Sep 2000 18:09:07 -0400 From: Nelson Organization: cmet X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.12-20smp i686) X-Accept-Language: en MIME-Version: 1.0 To: Jie Liang , "pgsql-general@hub.org" , "pgsql-novice@hub.org" , "pgsql-sql@hub.org" Subject: [SQL] how to store a query, that results in a table References: <39CB65A0.9DEF7ABB@cmet.net> <39CBD205.9A922DDE@ipinc.com> Content-Type: multipart/mixed; boundary="------------2C2BE48F96D7B5C49D65EB1E" X-Archive-Number: 200009/671 This is a multi-part message in MIME format. --------------2C2BE48F96D7B5C49D65EB1E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit thank you jie Liang for your response, but my problems are: 1. How to store a query in the database. 2. How to give a parameter from outside of database, for example: select * from table1 where row1 = my_parameter_outside. Give me an example please. --------------2C2BE48F96D7B5C49D65EB1E Content-Type: text/x-vcard; charset=us-ascii; name="nbrito.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Nelson Content-Disposition: attachment; filename="nbrito.vcf" begin:vcard n:brito;nelson x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:nbrito@cmet.net x-mozilla-cpt:;28480 fn:nelson brito end:vcard --------------2C2BE48F96D7B5C49D65EB1E--