how to store a query, that results in a table

Поиск
Список
Период
Сортировка
От root
Тема how to store a query, that results in a table
Дата
Msg-id 39CB65A0.9DEF7ABB@cmet.net
обсуждение исходный текст
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Enrico Comini"
Дата:
Сообщение: Triggers
Следующее
От: David McWherter
Дата:
Сообщение: Re: Re: Large Objects