Received: from mail2.panix.com (mail2.panix.com [166.84.0.213]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3TH9X362007 for ; Sun, 29 Apr 2001 13:09:33 -0400 (EDT) (envelope-from eliel@panix.com) Received: from blockhead (eliel.dialup.access.net [166.84.205.53]) by mail2.panix.com (Postfix) with SMTP id EE9A28EDE for ; Sun, 29 Apr 2001 13:09:31 -0400 (EDT) From: "Eliel Mamousette" To: Subject: SQL Server -> Postgres migration: Stored Procedure replacement? Date: Sun, 29 Apr 2001 13:08:02 -0400 Message-ID: <000401c0d0ce$f3081f10$2001a8c0@blockhead> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <00e801c0cea6$dc848820$5a2510ac@corp.enron.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200104/1214 X-Sequence-Number: 8531 What's the standard methodology in the Postgres world for creating functions (SQL Server calls them 'stored procedures') that return more than one column of data per row? I have tried using the SETOF operand in the CREATE FUNCTION statement, and that allows me to return more than one row, but haven't had any luck with specifying more than one return type and hence more than one column. Thanks in advance for any assistance, eliel