Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 8C66A6329A3 for ; Fri, 3 Sep 2010 22:29:53 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 30823-08 for ; Sat, 4 Sep 2010 01:29:44 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw05.intertain.com (gw05.intertain.com [209.101.231.5]) by mail.postgresql.org (Postfix) with ESMTP id 0008563295B for ; Fri, 3 Sep 2010 22:29:45 -0300 (ADT) Received: from [192.168.1.184] (softdnserr [::ffff:192.168.1.184]) (AUTH: LOGIN rsmith, TLS: TLSv1/SSLv3,256bits,AES256-SHA) by gw05.intertain.com with esmtp; Fri, 03 Sep 2010 18:29:42 -0700 id 008FC005.4C81A106.00000BB7 Message-ID: <4C81A105.7070703@10kinfo.com> Date: Fri, 03 Sep 2010 18:29:41 -0700 From: Ralph Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: plpgsql language differences betw 7.4 and 8.0 Content-Type: multipart/alternative; boundary="------------010601090207040903030607" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201009/42 X-Sequence-Number: 35586 This is a multi-part message in MIME format. --------------010601090207040903030607 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi, 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? (I don't care about 'behind the scenes internals, more at the SQL level.) THANK! -- ?* Ralph Smith* Data Architech Web: http://www.10KInfo dot com Email: RSmith@10kInfo.com _____________________________ --------------010601090207040903030607 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi,

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?
(I don't care about 'behind the scenes internals, more at the SQL level.)

THANK!
--
 Ralph Smith
Data Architech
Web: http://www.10KInfo dot com
Email: RSmith@10kInfo.com
_____________________________
--------------010601090207040903030607--