Using aggregate functions with SELECT INTO or FOR .. LOOP?

From: Frank Miles <fpm(at)u(dot)washington(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Using aggregate functions with SELECT INTO or FOR .. LOOP?
Date: 2002-10-24 23:00:39
Message-ID: Pine.A41.4.44.0210241556140.22188-100000@homer13.u.washington.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would like to be able to use aggregate functions (e.g. sum(..))
in a pl/pgsql functions through SELECT INTO and FOR record IN SELECT ...
lines. The obvious (record.sum(..)) doesn't work when attempting to
recover the values. Is there a simple way of getting this information?

TIA!

-frank

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darren Ferguson 2002-10-24 23:06:48 Re: Using aggregate functions with SELECT INTO or FOR ..
Previous Message Robert Treat 2002-10-24 22:40:09 Re: Hot Backup