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 ED8D23A5BC4 for ; Wed, 26 Jan 2005 15:02:08 +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 26357-09 for ; Wed, 26 Jan 2005 15:01:57 +0000 (GMT) Received: from web53702.mail.yahoo.com (web53702.mail.yahoo.com [206.190.37.23]) by svr1.postgresql.org (Postfix) with SMTP id 8F7283A5BEC for ; Wed, 26 Jan 2005 15:01:59 +0000 (GMT) Received: (qmail 49571 invoked by uid 60001); 26 Jan 2005 15:01:59 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=rCMM+mnrtED4V2SaJNdg/oDYCdKBp14GQUb7aFqqStUS/Pn0VKKw7po8zDp1zC7zxTniUymneu+c/HzCVDZPspn3Bhn/oDZncMMdPpHBGH2m+uC3xzMKQEp4RWpyL7zpJPsXX4SftbA4Yqi39aNJJuePUjDYnWpf35vZgI4EBPs= ; Message-ID: <20050126150159.49567.qmail@web53702.mail.yahoo.com> Received: from [199.217.234.6] by web53702.mail.yahoo.com via HTTP; Wed, 26 Jan 2005 07:01:59 PST Date: Wed, 26 Jan 2005 07:01:59 -0800 (PST) From: George Essig Subject: Re: Moving from Transact SQL to PL/pgsql To: Duffy House Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.374 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200501/258 X-Sequence-Number: 20046 > ... > Where can I find > primer on PL/pgsql, with lots of examples? > ... Download openacs at http://openacs.org/projects/openacs/download/. Look at directories matching the pattern openacs-*/packages/*/sql/postgresql/. The older openacs version 4.6.3 has more examples than openacs 5. George Essig