X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4C3DCD1B4AD for ; Mon, 29 Dec 2003 02:16:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 33542-02 for ; Sun, 28 Dec 2003 22:15:34 -0400 (AST) Received: from quality.qadas.com (quality.qadas.com [204.227.16.4]) by svr1.postgresql.org (Postfix) with ESMTP id A67C2D1B487 for ; Sun, 28 Dec 2003 22:15:30 -0400 (AST) Received: from quality.qadas.com (localhost [127.0.0.1]) by quality.qadas.com (8.12.10/8.12.10) with ESMTP id hBT2FRB3005227; Sun, 28 Dec 2003 19:15:27 -0700 (MST) Received: (from mfuhr@localhost) by quality.qadas.com (8.12.10/8.12.10/Submit) id hBT2FR4F005226; Sun, 28 Dec 2003 19:15:27 -0700 (MST) Date: Sun, 28 Dec 2003 19:15:27 -0700 From: Michael Fuhr To: beyaRecords - The home Urban music Cc: pgsql-sql@postgresql.org Subject: Re: Stored Procedures Message-ID: <20031228191527.A3221@quality.qadas.com> References: <4AAEDD32-39A2-11D8-B49F-0003938366A4@beya-records.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4AAEDD32-39A2-11D8-B49F-0003938366A4@beya-records.com>; from uzo@beya-records.com on Mon, Dec 29, 2003 at 01:57:00AM +0000 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/213 X-Sequence-Number: 16379 On Mon, Dec 29, 2003 at 01:57:00AM +0000, beyaRecords - The home Urban music wrote: > > I am new to this list and the world of postgreSQL, and would like to > know how create stored procedures in postgreSQL. If you're new to PostgreSQL then have a look at the documentation: http://www.postgresql.org/docs/ To learn about stored procedures, see the "Server Programming" part, especially the "Extending SQL" and "PL/pgSQL - SQL Procedural Language" chapters: http://www.postgresql.org/docs/current/static/server-programming.html http://www.postgresql.org/docs/current/static/extend.html http://www.postgresql.org/docs/current/static/plpgsql.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/