Skip site navigation (1) Skip section navigation (2)

Passing multiple rows to a function?

From: Vitaly Belman <vitalyb(at)gmail(dot)com>
To: Postgresql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Passing multiple rows to a function?
Date: 2005-04-24 00:00:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I know that you can pass rows/records to a function but what about a
few rows? Is that possible?

For example, I'd like to send to a function a number of rows from the
"workers" table (e.g "select * from workers where age<10") and the
function will return their summed salary.

 ICQ: 1912453
 AIM: VitalyB1984
 MSN: tmdagent(at)hotmail(dot)com
 Yahoo!: VitalyBe


pgsql-novice by date

Next:From: Michael FuhrDate: 2005-04-24 00:21:31
Subject: Re: Passing multiple rows to a function?
Previous:From: Bruno Wolff IIIDate: 2005-04-23 17:38:44
Subject: Re: SSL use

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group