X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9A6D1476531 for ; Wed, 14 May 2003 22:34:45 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 93041-01 for ; Wed, 14 May 2003 22:34:40 -0400 (EDT) Received: from shield.nordlb.lv (shield.pirmabanka.lv [195.114.57.4]) by postgresql.org (Postfix) with ESMTP id 38948476539 for ; Wed, 14 May 2003 22:34:39 -0400 (EDT) Received: from wall2.pirmabanka.lv (wall2-pub.nordlb.lv [195.114.57.14]) by shield.nordlb.lv (8.12.9/8.12.9) with SMTP id h4F2Ygbg019418 for ; Thu, 15 May 2003 05:34:42 +0300 Received: from share.nordlb.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Thu, 15 May 2003 05:34:40 +0300 (EET DST) Received: from pc311x1.nordlb.lv (localhost.localdomain [127.0.0.1]) by nordlb.lv (8.11.6/8.11.6) with SMTP id h4F2YeY23901 for ; Thu, 15 May 2003 05:34:40 +0300 Received: (qmail 3045 invoked by uid 100); 15 May 2003 02:37:21 -0000 Date: Thu, 15 May 2003 05:37:21 +0300 From: "Victor Yegorov" To: "Steven Chau" Cc: Subject: Re: Newbie question: How to CREATE FUNCTION Message-ID: <20030515023721.GG1549@nordlb.lv> Mail-Followup-To: "Steven Chau" , References: <00b501c31a86$6a6a3130$4706050a@stevenc> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <00b501c31a86$6a6a3130$4706050a@stevenc> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/306 X-Sequence-Number: 13471 * Steven Chau [15.05.2003 05:09]: > > Hi, > > I am new to PostgreSQL. So, please forgive my ignorane. > > Can anyone tell me how to create a FUNCTION in PostgreSQL that performs the > same duty as the following MsSQL stored procedure? Go to www.postgresql.org/docs/ and select interactive documentation for your version of Postgres. SQL commands are described in Reference Manual. Procedural languages and Server-side programming - in Programmer's manual. Also, take a glance at `createlang' in section `Client applications' of Reference manual. -- Victor Yegorov