how to store a query, that results in a table

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

Вложения

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

Предыдущее
От: root
Дата:
Сообщение: how to store a query, that results in a table
Следующее
От: Nelson
Дата:
Сообщение: [SQL] how to store a query, that results in a table