Received: from mail-ob03.one.net.au (mail-ob03.one.net.au [61.12.0.163]) by hub.org (8.10.1/8.10.1) with ESMTP id e8MNpVs10390; Fri, 22 Sep 2000 19:51:32 -0400 (EDT) Received: Received: [from darthvader.e-magine.com.au (async169-syd-isp-238.nas.one.net.au [61.12.16.170]) by mail-ob03.one.net.au with ESMTP id e8MNo6406373; Sat, 23 Sep 2000 09:50:08 +1000 (EST)] Message-Id: <4.3.2.7.0.20000923111232.00b65758@mail.e-magine.com.au> X-Sender: e-magine@mail.e-magine.com.au X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Sat, 23 Sep 2000 11:14:29 +1000 To: Nelson , Jie Liang , "pgsql-general@hub.org" , "pgsql-novice@hub.org" , "pgsql-sql@hub.org" From: Keith Wong Subject: Re: how to store a query, that results in a table In-Reply-To: <39CBD883.9A63F0C6@cmet.net> References: <39CB65A0.9DEF7ABB@cmet.net> <39CBD205.9A922DDE@ipinc.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200009/188 This is not really possible with postgresql at the moment. Better off trying to work around, perhaps using a view. That way you have a way to change the select statement without actually modifying your client code. Keith. At 06:09 PM 22/09/2000 -0400, Nelson wrote: >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. > >