Postgres Pro
Downloads
Home   >   mailing lists

Using aggregate functions with SELECT INTO or FOR .. LOOP? - Mailing list pgsql-general

From Frank Miles
Subject Using aggregate functions with SELECT INTO or FOR .. LOOP?
Date
Msg-id Pine.A41.4.44.0210241556140.22188-100000@homer13.u.washington.edu
Whole thread Raw
Responses Re: Using aggregate functions with SELECT INTO or FOR ..  (Darren Ferguson <darren@crystalballinc.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Hot Backup
Next
From: Darren Ferguson
Date:
Subject: Re: Using aggregate functions with SELECT INTO or FOR ..