Received: from news.tht.net (news.hub.org [216.126.91.242])
	by hub.org (8.9.3/8.9.3) with ESMTP id RAA36198
	for <pgsql-docs@postgresql.org>; Tue, 22 Feb 2000 17:39:03 -0500 (EST)
	(envelope-from news@news.tht.net)
Received: (from news@localhost) by news.tht.net (8.9.3/8.9.3) id RAA49070
	for pgsql-docs@postgresql.org; Tue, 22 Feb 2000 17:36:11 -0500 (EST)
	(envelope-from news)
X-Authentication-Warning: news.tht.net: news set sender to <news> using -f
From: "CAMPZ" <rcstyles@email.msn.com>
Subject: Help w/procedures
Date: Tue, 22 Feb 2000 17:32:10 -0500
Lines: 14
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <uI6khTYf$GA.277@cpmsnbbsa03>
X-Newsgroups: comp.databases.postgresql.docs
To: pgsql-docs@postgresql.org

Hello,

I need help writing a procedure that will adding a group.

add_group:
- pass values for group name and 2 client ids and if valid (group name must
be not null and unique, client
ids must be not null and valid, client must not already belong to a group)
and add row to group table
- return value of team.id assigned, otherwise return a value of 0

Any help would be great thanks