From: | root <nbrito(at)cmet(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | how to store a query, that results in a table |
Date: | 2000-09-22 14:54:01 |
Message-ID: | 39CB7289.EFF35E68@cmet.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> 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.
Attachment | Content-Type | Size |
---|---|---|
nbrito.vcf | text/x-vcard | 150 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2000-09-22 21:41:25 | Re: how to store a query, that results in a table |
Previous Message | root | 2000-09-22 13:58:56 | how to store a query, that results in a table |