Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 3C38E6318F3 for ; Fri, 3 Sep 2010 23:48:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 63561-01 for ; Sat, 4 Sep 2010 02:48:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 545F962FBBF for ; Fri, 3 Sep 2010 23:48:38 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o842mXKr004879; Fri, 3 Sep 2010 22:48:33 -0400 (EDT) To: Ralph Smith cc: pgsql-admin@postgresql.org Subject: Re: plpgsql language differences betw 7.4 and 8.0 In-reply-to: <4C81A105.7070703@10kinfo.com> References: <4C81A105.7070703@10kinfo.com> Comments: In-reply-to Ralph Smith message dated "Fri, 03 Sep 2010 18:29:41 -0700" Date: Fri, 03 Sep 2010 22:48:33 -0400 Message-ID: <4878.1283568513@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/43 X-Sequence-Number: 35587 Ralph Smith writes: > I'm stuck using v7.4 and more than once I've come across examples that > just don't work here. > e.g.: CREATE or ...FUNCTION.... AS $mydelim$ > $mydelim$ doesn't work but plain old apostrophe does. > Now it looks like ELSIF is different. > Is there a location where I can find these changes? Try the release notes. http://www.postgresql.org/docs/9.0/static/release.html BTW, you need to think seriously about getting "unstuck". 7.4's remaining support lifespan is measured in days, not weeks. You need to be making plans *now* to move to 8.2 or later. regards, tom lane