Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A0B9747580E for ; Wed, 14 Aug 2002 13:25:16 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id BCD2747549E for ; Wed, 14 Aug 2002 13:25:15 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g7EHPFVk009595; Wed, 14 Aug 2002 13:25:15 -0400 (EDT) To: Sue Humphrey Cc: pgsql-sql@postgresql.org Subject: Re: sql function examples requested (! select) In-reply-to: <20020814163942.52842.qmail@web20607.mail.yahoo.com> References: <20020814163942.52842.qmail@web20607.mail.yahoo.com> Comments: In-reply-to Sue Humphrey message dated "Wed, 14 Aug 2002 09:39:42 -0700" Date: Wed, 14 Aug 2002 13:25:14 -0400 Message-ID: <9594.1029345914@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/238 X-Sequence-Number: 9084 Sue Humphrey writes: > I would like examples of functions using update, insert and > delete, where LANGUAGE 'SQL', both how to write them and how to > use them. Have you read the documentation? http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/xfunc-sql.html The first couple of examples seem to cover the territory ... regards, tom lane