X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7691A3A52A9 for ; Mon, 24 Jan 2005 03:19:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20093-01 for ; Mon, 24 Jan 2005 03:19:38 +0000 (GMT) Received: from mta4.srv.hcvlny.cv.net (mta4.srv.hcvlny.cv.net [167.206.5.70]) by svr1.postgresql.org (Postfix) with ESMTP id 5F8593A52A8 for ; Mon, 24 Jan 2005 03:19:41 +0000 (GMT) Received: from duffyhou (ool-4357a243.dyn.optonline.net [67.87.162.67]) by mta4.srv.hcvlny.cv.net (iPlanet Messaging Server 5.2 HotFix 1.25 (built Mar 3 2004)) with SMTP id <0IAS0098KX8MN8@mta4.srv.hcvlny.cv.net> for pgsql-sql@postgresql.org; Sun, 23 Jan 2005 22:19:41 -0500 (EST) Date: Sun, 23 Jan 2005 22:22:23 -0500 From: Duffy House Subject: Moving from Transact SQL to PL/pgsql To: pgsql-sql@postgresql.org Message-id: MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT Importance: Normal X-Priority: 3 (Normal) X-MSMail-priority: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.892 tagged_above=0 required=5 tests=DNS_FROM_RFC_POST, FROM_ENDS_IN_NUMS X-Spam-Level: * X-Archive-Number: 200501/228 X-Sequence-Number: 20016 Hello: I am implementing a new system using Postgres. Well most of the system will be new, but some parts will be very similar to a system currently running under M$-SQL. The first issue will be getting up to speed on PL/pgsql. Where can I find primer on PL/pgsql, with lots of examples? How silimar is PL/pgsql to PL/SQL under Oracle? Thanks in Advance. kd