From: root <nbrito@cmet.net>
To: pgsql-sql-owner@hub.org
To: pgsql-sql@hub.org
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
To: pgsql-general@hub.org
Subject: how to store a query, that results in a table
Date: Fri, 22 Sep 2000 09:58:56 -0400
Message-ID: <39CB65A0.9DEF7ABB@cmet.net> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: nbrito@cmet.net, pgsql-sql-owner@hub.org, pgsql-sql@hub.org, pgsql-general@postgresql.org, pgsql-general@hub.org
Subject: Re: how to store a query, that results in a table
In-Reply-To: <39CB65A0.9DEF7ABB@cmet.net>
References: <39CB65A0.9DEF7ABB@cmet.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox