Passing a table to PL/pgSQL

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Passing a table to PL/pgSQL
Date: 2001-02-25 01:17:16
Message-ID: 20010224181715.A16471@cc.usu.edu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 parameter have 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

Browse pgsql-sql by date

  From Date Subject
Next Message J.H.M. Dassen Ray 2001-02-25 16:29:35 Re: ask for help !!! (emergency case)
Previous Message Ian Lance Taylor 2001-02-24 23:15:10 Re: greetings