Re: what's wrong with this code?

On Thursday, June 18, 2015, Michael Wood <esiotrot(at)gmail(dot)com> wrote:

> The aliases were quoted, so I don't think they are a problem.
>
> Check the spelling of "pop_stdev". In your query you only had one "d" but
> you talk about "pop_stddev" and Amul said it is actually called
> "stddev_pop".
>
> --
> Michael Wood
> On 18 Jun 2015 10:12 PM, "Jude DaShiell" <jdashiel(at)panix(dot)com
> <javascript:_e(%7B%7D,'cvml','jdashiel(at)panix(dot)com');>> wrote:
>
>> 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(at)yahoo(dot)co(dot)in
>>> <javascript:_e(%7B%7D,'cvml','sul_amul(at)yahoo(dot)co(dot)in');>>
>>> To: Jude DaShiell <jdashiel(at)panix(dot)com
>>> <javascript:_e(%7B%7D,'cvml','jdashiel(at)panix(dot)com');>>,
>>> "pgsql-novice(at)postgresql(dot)org
>>> <javascript:_e(%7B%7D,'cvml','pgsql-novice(at)postgresql(dot)org');>" <
>>> pgsql-novice(at)postgresql(dot)org
>>> <javascript:_e(%7B%7D,'cvml','pgsql-novice(at)postgresql(dot)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
>>>
>>>
>> --
>>
>>
>>
>> --
>> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org
>> <javascript:_e(%7B%7D,'cvml','pgsql-novice(at)postgresql(dot)org');>)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-novice
>>
>
What database tool are you using? psql and many others would point out the
exact error in context of the query.

merlin