From: Richard Huxton <dev@archonet.com>
To: Andreas Tille <tillea@rki.de>
Subject: Re: Scaler forms as function arguments
Date: Thu, 27 Nov 2003 17:31:38 +0000
User-Agent: KMail/1.5
Cc: PostgreSQL SQL <pgsql-sql@postgresql.org>
References: <Pine.LNX.4.56.0311261255210.17774@wr-linux02.rki.ivbb.bund.de>
	<3FC61ED4.6050205@joeconway.com>
	<Pine.LNX.4.56.0311271739120.12965@wr-linux02.rki.ivbb.bund.de>
In-Reply-To: <Pine.LNX.4.56.0311271739120.12965@wr-linux02.rki.ivbb.bund.de>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200311271731.38313.dev@archonet.com>

On Thursday 27 November 2003 16:40, Andreas Tille wrote:
> 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?

No - look carefully at Joe's response. He's calling it like:

SELECT * FROM my_function();

You treat the function like a table.

-- 
  Richard Huxton
  Archonet Ltd