Amul, you are correct stddev_pop() is the correct way to call that
function. Thanks much.
On Thu, 18 Jun 2015, Jude DaShiell wrote:
> Date: Thu, 18 Jun 2015 16:11:26
> From: Jude DaShiell <jdashiel@panix.com>
> To: amul sul <sul_amul@yahoo.co.in>,
> "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
> Subject: Re: [NOVICE] what's wrong with this code?
>
> 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
>>
>
>
--