joining a table with a function

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема joining a table with a function
Дата
Msg-id BAY8-F13ZYNX6Mma0n70001af8a@hotmail.com
обсуждение исходный текст
Список pgsql-sql
hi all,

i have a function of a user defined type it returns a record of values but 
just a row.
select * from rec_f_consultar_alumno(a.ent_codigo, a.alu_codigo)

what i want to do now is a select in wich i can do a seq scan or an index 
scan of a table and
pass the values i retrieve into the function. the select have to retrieve 
the result of the function.
i can do that whit a function with setof but i want to know if it is 
possible to do it with a select

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail



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

Предыдущее
От: sad
Дата:
Сообщение: type regclass casting
Следующее
От: "kasper"
Дата:
Сообщение: multi results with functions