X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5C01D3A536F for ; Tue, 30 Nov 2004 04:56:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41013-05 for ; Tue, 30 Nov 2004 04:56:33 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 7BC1C3A52FD for ; Tue, 30 Nov 2004 04:56:29 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id iAU4uNFX019957 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Mon, 29 Nov 2004 21:56:26 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id iAU4uNit087498; Mon, 29 Nov 2004 21:56:23 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id iAU4uNfK087497; Mon, 29 Nov 2004 21:56:23 -0700 (MST) (envelope-from mfuhr) Date: Mon, 29 Nov 2004 21:56:23 -0700 From: Michael Fuhr To: RobertD.Stewart@ky.gov Cc: pgsql-sql@postgresql.org Subject: Re: stored procedures in postgresql user plpgsql Message-ID: <20041130045623.GA87429@winnie.fuhr.org> References: <06AF099D94D33B4D9120504521D6539D02903C64@agency33.state.ky.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <06AF099D94D33B4D9120504521D6539D02903C64@agency33.state.ky.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/295 X-Sequence-Number: 19613 Please Cc the mailing list when you respond -- that way others can participate in and learn from the discussion. Also, if you have a new question then please start a new thread with a relevant Subject header. On Mon, Nov 29, 2004 at 10:12:59PM -0500, RobertD.Stewart@ky.gov wrote: > Thanks for the help > > That is what I needed > > Do you have any examples of insert statements for multiple variable > > I'm trying to create a web page that would call these functions See the documentation for the INSERT statement: http://www.postgresql.org/docs/7.4/static/sql-insert.html If you're having trouble with something, then please describe what you're trying to do and the difficulties you're having. It's helpful if you post the SQL statements you're executing along with a description of what you want to happen and what actually does happen. For the latter, including the output from a psql session can be useful. -- Michael Fuhr http://www.fuhr.org/~mfuhr/