| From: | root <nbrito(at)cmet(dot)net> |
|---|---|
| To: | pgsql-sql-owner(at)hub(dot)org, pgsql-sql(at)hub(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)hub(dot)org |
| Subject: | how to store a query, that results in a table |
| Date: | 2000-09-22 13:58:56 |
| Message-ID: | 39CB65A0.9DEF7ABB@cmet.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David McWherter | 2000-09-22 14:21:12 | Re: Re: Large Objects |
| Previous Message | Fernán Agüero | 2000-09-22 13:54:46 | Re: perl Pg module and result status |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | root | 2000-09-22 14:54:01 | how to store a query, that results in a table |
| Previous Message | root | 2000-09-22 13:36:10 | how to store a query, that results in a table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2000-09-22 15:01:06 | Re: [Fwd: Re: no ORDER BY in subselects?] |
| Previous Message | Tom Lane | 2000-09-22 02:06:27 | Re: C functions and int8? |