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 fAFLLWm45342 for ; Thu, 15 Nov 2001 16:21:37 -0500 (EST) (envelope-from roland@astrofoto.org) Received: (from roland@localhost) by mail.astrofoto.org (8.11.6/8.11.6) id fAFLLXF18556; Thu, 15 Nov 2001 16:21:33 -0500 To: pgsql-sql@postgresql.org Subject: Re: PL/pgSQL examples NOT involving functions References: From: Roland Roberts Date: 15 Nov 2001 16:21:33 -0500 In-Reply-To: Message-ID: Lines: 27 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.0.105 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/226 X-Sequence-Number: 5609 >>>>> "Josh" == Josh Berkus writes: Josh> Please do not cross-post to multiple lists. Hmm, there were some complaints recently on the hackers list about things being posted on only one list. And a significant chunk of the mail I am getting from lists shows it was posted to more than one list. >> How can I write a few lines of PL/pgSQL which do not involve >> creating a function? I can find no examples of this in the >> docs, but say I would like to do something like Josh> You can't. PL/pgSQL, like PL/Perl and PL/Tcl, may only be Josh> used in functions. So how would I convert an insert to an update when I detect a tuple is already present in the database? Do I have to write the whole thing in Perl/Tcl/whatever and do the conversion there? 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