Received: from mailhub.westfield-cos.com (mailhub.westfield-cos.com [12.4.177.228]) by postgresql.org (Postfix) with ESMTP id ADF5E475EB4 for ; Fri, 8 Mar 2002 15:18:54 -0500 (EST) Subject: New user - creating function question To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0.7 March 21, 2001 Message-ID: From: TimothyReaves@westfieldgrp.com Date: Fri, 8 Mar 2002 15:16:01 -0500 X-MIMETrack: Serialize by Router on MAILHUB/Westfield_Mailhub(Release 5.0.8 |June 18, 2001) at 03/08/2002 03:18:08 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Archive-Number: 200203/104 X-Sequence-Number: 6985 Hello all. I'm trying to create a stored procedure that will accept a value and return a result set. I use the parameter in the select statement. But I can't seem to get it to work. When I call the function, I get: ERROR: parser: parse error at or near "select_2" Could someone point me to a simple function that performs a select and returns the result set? Thanks!