From: Richard Huxton <dev@archonet.com>
To: Andreas Tille <tillea@rki.de>
Cc: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Re: Scaler forms as function arguments
Date: Thu, 27 Nov 2003 17:31:38 +0000
Message-ID: <200311271731.38313.dev@archonet.com> (raw)
In-Reply-To: <Pine.LNX.4.56.0311271739120.12965@wr-linux02.rki.ivbb.bund.de>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, tillea@rki.de
Subject: Re: Scaler forms as function arguments
In-Reply-To: <200311271731.38313.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox