Received: from bedrock.hboc.com (hboc.com [208.138.70.3]) by hub.org (8.9.1/8.9.1) with SMTP id MAA28931 for ; Thu, 7 Jan 1999 12:47:00 -0500 (EST) (envelope-from KMarkle@IMNET.com) Received: from mrteal.hboc.com by bedrock.hboc.com via smtpd (for postgresql.org [209.167.229.14]) with SMTP; 7 Jan 1999 17:47:00 UT Received: from dmz.hboc.com ([149.21.188.79]) by mrteal.hboc.com (8.8.5/8.8.5) with SMTP id MAA19617 for ; Thu, 7 Jan 1999 12:46:58 -0500 (EST) Received: from [149.21.188.79] by dmz.hboc.com via smtpd (for mrteal.hboc.com [192.168.0.10]) with SMTP; 7 Jan 1999 17:46:57 UT Received: by CORP6 with Internet Mail Service (5.0.1458.49) id ; Thu, 7 Jan 1999 12:44:59 -0500 Message-ID: <549B01194628D11184EF00805FA6DCBAF3C14A@CORP2> From: Kim Markle To: "'pgsql-sql@postgresql.org'" Subject: Postgres functions and Stored Procedures? Date: Thu, 7 Jan 1999 12:44:45 -0500 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain I am new to Postgres and have researched the mail archives but I have not found the answer for this (only questions). I am very familiar with using MS SQL 6.5 and have written tons of SP's. The example below is how one could write a SP for MS SQL which returns a record set. My question is how do I do this with Postgres functions? create procedure ListAIS as select aisname as "AIS Name", aisdescription as "Description", username as "User Name", password as "Password" from ais_list GO GRANT EXECUTE ON dbo.EPRS_ListAIS TO USER GO Thanks, Kim Markle Tivoli Kennels