X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 788BED1DA6C for ; Thu, 15 Jan 2004 19:05:36 +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 47459-05 for ; Thu, 15 Jan 2004 15:05:05 -0400 (AST) Received: from ganymede.hub.org (u46n208.hfx.eastlink.ca [24.222.46.208]) by svr1.postgresql.org (Postfix) with ESMTP id 7E83FD1B4BD for ; Thu, 15 Jan 2004 15:05:04 -0400 (AST) Received: from [192.168.1.106] (unknown [192.168.1.106]) by ganymede.hub.org (Postfix) with ESMTP id 04FFD3B270; Thu, 15 Jan 2004 15:02:04 -0400 (AST) Subject: Re: Problem with plpgsql function From: Chris Bowlby Reply-To: chris@hub.org To: Joe Conway Cc: chris@hub.org, pgsql-sql@postgresql.org In-Reply-To: <4006E059.7030802@joeconway.com> References: <1074191967.33449.11.camel@morpheus.hub.org> <4006E059.7030802@joeconway.com> Content-Type: text/plain Organization: Hub.Org Networking Services Message-Id: <1074193560.33449.13.camel@morpheus.hub.org> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Thu, 15 Jan 2004 15:06:01 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/132 X-Sequence-Number: 16525 Ack, I knew it was something small, I was under the impression that I had been using that, it just took someone to point it out to make me look again :>... thanks.. On Thu, 2004-01-15 at 14:47, Joe Conway wrote: > Chris Bowlby wrote: > > select get_account_info('test.com'); > > > > I get this error: > > > > ERROR: set-valued function called in context that cannot accept a set > > This is the "classic" SRF error -- you need to use an SRF like a > relation in the FROM clause, so do this instead: > > select * FROM get_account_info('test.com'); > > HTH, > > Joe -- Chris Bowlby Hub.Org Networking Services