Re: selecting a column average into table

This should work:

-- don't have to create the table if you already have one.
create table foo (
answer float;
)

insert into foo (answer) select avg(numbers) from nebbish;

JM

----- Original Message -----
From: "Shawhan, Douglas (GEAE, GECC)" <douglas(dot)shawhan(at)ae(dot)ge(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, June 05, 2001 12:19 PM
Subject: [NOVICE] selecting a column average into table

> Weeeellll...
>
> I wish to select the average of a column populated with integers into a
> table
>
> I have established in my mind that:
>
> select avg(nebbish.numbers) into shebang from numbers ;
>
> ain't going to cut it. Can anyone point me in the right direction?
>
> d
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>