Received: from cmet.net ([216.72.177.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e8MDsbs66677; Fri, 22 Sep 2000 09:54:37 -0400 (EDT) Received: from cmet.net (root@[216.72.176.22]) by cmet.net (8.8.5/8.8.5) with ESMTP id JAA19928; Fri, 22 Sep 2000 09:50:05 -0400 (CST) Message-ID: <39CB65A0.9DEF7ABB@cmet.net> Date: Fri, 22 Sep 2000 09:58:56 -0400 From: root Reply-To: nbrito@cmet.net 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: pgsql-sql-owner@hub.org, pgsql-sql@hub.org, pgsql-general@postgresql.org, pgsql-sql@postgresql.org, pgsql-general@hub.org Subject: how to store a query, that results in a table Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/650 hi. I have a problem. I require to store a query sql in postgresql-7.0 like: example. select * from table1 where row1(table1)=parameter1 If i execute this query directly, I don't have problem. I want to store this query in order to execute from a client program (visual basic 6.0), but i don't know how to? I tried to store the query like a function (create function ...), but it was impossible to find a way in order to obtain a table like result. Only we could obtain a single row by using the rtype " returns setof varchar". I hope a soon answer. Thank you. Nelson B.