Обсуждение: Passing a table to PL/pgSQL

Поиск
Список
Период
Сортировка

Passing a table to PL/pgSQL

От
Roberto Mello
Дата:
Hi,
I am trying to learn how can I pass a table to PL/pgSQL functions and
what can I do with them. I have heard somethings about these things, but
I'd like to know for certain.
Especifically:
- Can I pass a table to PL/pgSQL?- Can I pass a parameter that's a member of a table (e.g.  users.user_id%TYPE)?- Can a
parameterhave a default value?
 
Thanks,
-Roberto Mello
P.S: I searched lots in the PG search engine, but couldn't find
anything.
-- 
Computer Science            Utah State University
Space Dynamics Laboratory        Web Developer
USU Free Software & GNU/Linux Club     http://fslc.usu.edu
My web site: http://www.brasileiro.net