Received: from xyzzy.lan.internal (d150-146-168.home.cgocable.net [24.150.146.168]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAM19rm77083 for ; Wed, 21 Nov 2001 20:09:54 -0500 (EST) (envelope-from drew@xyzzy.dhs.org) Received: from localhost ([127.0.0.1] helo=there ident=drew) by xyzzy.lan.internal with smtp (Exim 3.32 #1 (Debian)) id 166iNA-0002ib-00; Wed, 21 Nov 2001 20:09:48 -0500 Content-Type: text/plain; charset="iso-8859-1" From: "Andrew G. Hammond" To: Roland Roberts , pgsql-sql@postgresql.org Subject: Re: PL/pgSQL examples NOT involving functions Date: Wed, 21 Nov 2001 20:09:42 -0500 X-Mailer: KMail [version 1.3.2] References: <20011119135117.16760.qmail@ns.krot.org> In-Reply-To: MIME-Version: 1.0 Message-Id: Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fAM1MXL77291 X-Archive-Number: 200111/307 X-Sequence-Number: 5689 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2001 November 19 09:42 am, Roland Roberts wrote: > >>>>> "Aasmund" == Aasmund Midttun Godal writes: > >> So I *could* create a pl/pgsql function and call it like that, > >> but since pl/pgsql procedures aren't compiled I wondered if I > >> could do it inline. > > Aasmund> I do believe they are compiled. > > Hmm, I'm going to have to look over the docs again. I missed that > change; I'm pretty sure that as of 6.2 there were *not* compiled and > that was clearly stated in the docs. You're right, they're interpreted at run time. If you want proof, just write a bogus function definition. It'll CREATE just fine, but barf with a syntax error when you try and execute it. - -- Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/ 56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481 5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1 "To blow recursion you must first blow recur" -- me -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iEYEARECAAYFAjv8UFoACgkQCT73CrRXhLHSBwCeKEbDRUezLXS/Q1vP1VlXAdTD RVoAoI8qA8Q5C2hVdXwPGBt/3UnOKF4T =8+Us -----END PGP SIGNATURE-----