Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id A1CEB475A9B
	for <pgsql-sql@postgresql.org>; Wed, 14 Aug 2002 12:39:37 -0400 (EDT)
Received: from web20607.mail.yahoo.com (web20607.mail.yahoo.com
	[216.136.226.165])
	by postgresql.org (Postfix) with SMTP id 1DB0547549E
	for <pgsql-sql@postgresql.org>; Wed, 14 Aug 2002 12:39:37 -0400 (EDT)
Message-ID: <20020814163942.52842.qmail@web20607.mail.yahoo.com>
Received: from [209.49.25.191] by web20607.mail.yahoo.com via HTTP;
	Wed, 14 Aug 2002 09:39:42 PDT
Date: Wed, 14 Aug 2002 09:39:42 -0700 (PDT)
From: Sue Humphrey <sue_humphrey@yahoo.com>
Subject: sql function examples requested (! select)
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/236
X-Sequence-Number: 9082

I would like examples of functions using update, insert and
delete, where LANGUAGE 'SQL', both how to write them and how to
use them.

I've got examples of functions as selects coming out of my ears,
and PL/pgsql examples of more complex needs, but I just need to
run a simple UPDATE.  And I forsee an immediate need to do
deletes the same way.

Please feel free to either respond to the list, or in email, as
I subscribe to both.

Sue

__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com