Re: [GENERAL] table-valued arguments for functions

2009-12-22 Thread Adrian Klaver
On Tuesday 22 December 2009 5:46:25 am Wappler, Robert wrote: > > Assuming we could pass a bulk of rows as a table, the update could be > performed as follows: > > CREATE OR REPLACE FUNCTION update_tpl(measurements SETOF sensor_data) > RETURNS void VOLATILE AS $$ UPDATE temperature_per_location AS

Re: [GENERAL] table-valued arguments for functions

2009-12-22 Thread Wappler, Robert
> -Original Message- > From: Filip RembiaƂkowski [mailto:plk.zu...@gmail.com] > Sent: Monday, December 21, 2009 6:51 PM > To: Wappler, Robert > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] > > > 2009/12/21 Wappler, Robert > > > Hello, > > when defining functio