Re: looping over a small record set over and over in a function

Поиск
Список
Период
Сортировка
Искать
От
Craig Ringer
Тема
Re: looping over a small record set over and over in a function
Дата
Msg-id
1245553071.15432.30.camel@ayaki
Ответ на
looping over a small record set over and over in a function (Ivan Sergio Borgonovo)
Список
Дерево обсуждения
looping over a small record set over and over in a function Ivan Sergio Borgonovo <mail@webthatworks.it>
Re: looping over a small record set over and over in a function Craig Ringer <craig@postnewspapers.com.au>
cursors, temp tables, dynamic sql technique (was and is: looping over a small record set over and over in a function) Ivan Sergio Borgonovo <mail@webthatworks.it>
Re: temp tables, sessions, pgpool and disk Ivan Sergio Borgonovo <mail@webthatworks.it>
Re: temp tables, sessions, pgpool and disk Martijn van Oosterhout <kleptog@svana.org>
Re: temp tables, sessions, pgpool and disk Ivan Sergio Borgonovo <mail@webthatworks.it>
Re: looping over a small record set over and over in a function Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Re: looping over a small record set over and over in a function Ivan Sergio Borgonovo <mail@webthatworks.it>
Re: looping over a small record set over and over in a function John DeSoi <desoi@pgedit.com> 
On Fri, 2009-06-19 at 20:23 +0200, Ivan Sergio Borgonovo wrote:

> If I could easily load all the dataset into an array, loop through
> it and then just update the computed field it would be nice... but
> how?

Are you sure you _really_ need a PL/PgSQL function for this?

Can't you:

SELECT x.*, computefield(x, p)
FROM smalltable x, otherparams p;

or something along those lines?

--
Craig Ringer
В списке pgsql-general по дате отправления
Предыдущее
От: Gerhard Wiesinger
Дата:
Следующее
От: Peter Eisentraut
Дата:
FAQ