Received: from mail.astrofoto.org (dsl092-102-177.nyc2.dsl.speakeasy.net [66.92.102.177]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAJEgNm68836 for ; Mon, 19 Nov 2001 09:42:24 -0500 (EST) (envelope-from roland@astrofoto.org) Received: from kuiper.rlent.pnet (IDENT:root@kuiper.rlent.pnet [192.168.2.50]) by mail.astrofoto.org (8.11.6/8.11.6) with ESMTP id fAJEgRI28445 for ; Mon, 19 Nov 2001 09:42:27 -0500 Received: (from roland@localhost) by kuiper.rlent.pnet (8.11.6/8.11.0) id fAJEgRG03782; Mon, 19 Nov 2001 09:42:27 -0500 X-Authentication-Warning: kuiper.rlent.pnet: roland set sender to roland@rlenter.com using -f To: pgsql-sql@postgresql.org Subject: Re: PL/pgSQL examples NOT involving functions References: <20011115215049.14167.qmail@ns.krot.org> <20011119135117.16760.qmail@ns.krot.org> From: Roland Roberts Date: 19 Nov 2001 09:42:26 -0500 In-Reply-To: <20011119135117.16760.qmail@ns.krot.org> Message-ID: Lines: 18 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.1 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/270 X-Sequence-Number: 5652 >>>>> "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. roland -- PGP Key ID: 66 BC 3B CD Roland B. Roberts, PhD RL Enterprises roland@rlenter.com 76-15 113th Street, Apt 3B roland@astrofoto.org Forest Hills, NY 11375