X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 56A1CD1B4E9 for ; Sun, 9 Nov 2003 00:15:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 61273-10 for ; Sat, 8 Nov 2003 20:14:59 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 7B8F7D1B50F for ; Sat, 8 Nov 2003 20:14:56 -0400 (AST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3889551; Sat, 08 Nov 2003 16:15:42 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "Rich Seiersen" Subject: Re: plpgsql question Date: Sat, 8 Nov 2003 16:14:55 -0800 User-Agent: KMail/1.4.3 References: In-Reply-To: Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200311081614.55035.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/63 X-Sequence-Number: 15878 Rich, > That was my thought - I was fairly sure I fixed it though..... Do, really > need to be specific in terms of type in terms of int, or can I put numeric, INT and numeric are fairly different, and I believe that SRF return types are very fussy about data types; I wouldn't be surprised if you got an error for using an INT4 in place of an INT8. > and for varchar(30) I can just put varchar in my type definition. That I don't think will be a problem; varchar limits are indifferently supported anyway. -- Josh Berkus Aglio Database Solutions San Francisco