Received: from fslc.usu.edu (fslc.usu.edu [129.123.2.40]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1P1HKx22607 for ; Sat, 24 Feb 2001 20:17:20 -0500 (EST) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.usu.edu (8.11.2/8.11.2/Debian 8.11.2-1) id f1P1HGl16484 for pgsql-sql@postgresql.org; Sat, 24 Feb 2001 18:17:16 -0700 Date: Sat, 24 Feb 2001 18:17:16 -0700 From: Roberto Mello To: pgsql-sql@postgresql.org Subject: Passing a table to PL/pgSQL Message-ID: <20010224181715.A16471@cc.usu.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.12i X-Archive-Number: 200102/389 X-Sequence-Number: 1594 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