I am told pop_stddev(integer) does not exist and explicit type casting
may help. I'll be reading up on that in the next few minutes and see if
I can get this working. I know why the aliases were a problem or would
have been a problem too, the first word in every one of them that don't
work now was population with a blank space following it so psql probably
thought this idiot is trying to hang four aliases on a single string so
I got a yellow card for my efforts. The pop_stddev() is an aggregate
but one I've never used before inside psql or sql.
On Tue, 16 Jun 2015, amul sul wrote:
> Date: Tue, 16 Jun 2015 08:53:10
> From: amul sul <sul_amul@yahoo.co.in>
> To: Jude DaShiell <jdashiel@panix.com>,
> "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
> Subject: Re: [NOVICE] what's wrong with this code?
>
> What is the error?
>
> Can I ask what is pop_stdev? Postgres has stddev_pop database function not pop_stdev.
>
> regards,
> Amul
>
--