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 84D54D1B495 for ; Thu, 27 Nov 2003 16:41:31 +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 01014-06 for ; Thu, 27 Nov 2003 12:41:00 -0400 (AST) Received: from fw-berlin.bund.de (fw-berlin.bund.de [194.95.177.102]) by svr1.postgresql.org (Postfix) with ESMTP id 6F954D1B459 for ; Thu, 27 Nov 2003 12:40:58 -0400 (AST) Received: by fw-berlin.bund.de (8.11.6p2G/8.11.6) id hARGeuo10516 for pgsql-sql@postgresql.org; Thu, 27 Nov 2003 17:40:56 +0100 (CET) Received: (from localhost) by a2.fw.bln.ivbb.bund.de (MSCAN) id 3/a2.fw.bln.ivbb.bund.de/smtp-gw/mscan; Thu Nov 27 17:40:56 2003 Date: Thu, 27 Nov 2003 17:40:43 +0100 (CET) From: Andreas Tille X-X-Sender: tillea@wr-linux02.rki.ivbb.bund.de Cc: PostgreSQL SQL Subject: Re: Scaler forms as function arguments In-Reply-To: <3FC61ED4.6050205@joeconway.com> Message-Id: References: <200311261725.21975.dev@archonet.com> <3FC61ED4.6050205@joeconway.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-OriginalArrivalTime: 27 Nov 2003 16:33:10.0921 (UTC) FILETIME=[2571AF90:01C3B504] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/306 X-Sequence-Number: 16121 On Thu, 27 Nov 2003, Joe Conway wrote: > Andreas Tille wrote: > > test=# select PLpgSQLDepartmentSalaries() ; > > This should be: > regression=# select * from PLpgSQLDepartmentSalaries(); > departmentid | totalsalary > --------------+------------- > 1 | 80000 > 2 | 60000 > (2 rows) Well, it is easy to understand what it 'should be' reading the code - but it throws the error message I posted. Is this possibly a feature of a higher PostgreSQL version than 7.3.2? Kind regards Andreas.