Re: what's wrong with this code? - Mailing list pgsql-novice

It's how you find the function incorrectly listed if you do sr pgdoc
standard deviation.
Next I'm going to read up on turning this code into a stored procedure
since postgresql doesn't do median() I can calculate but will need to
use declaration statements for variables to do that.
The numerology research I intend to do with psql will need this
expertise in any event since psql doesn't do numerology to the level I
use it at all.

On Thu, 18 Jun 2015, Merlin Moncure wrote:

> Date: Thu, 18 Jun 2015 21:27:22
> From: Merlin Moncure <mmoncure@gmail.com>
> To: Michael Wood <esiotrot@gmail.com>
> Cc: Jude DaShiell <jdashiel@panix.com>,
>     PostgreSQL List - Novice <pgsql-novice@postgresql.org>,
>     amul sul <sul_amul@yahoo.co.in>
> Subject: Re: [NOVICE] what's wrong with this code?
>
> On Thursday, June 18, 2015, Michael Wood <esiotrot@gmail.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@panix.com
>> <javascript:_e(%7B%7D,'cvml','jdashiel@panix.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@yahoo.co.in
>>>> <javascript:_e(%7B%7D,'cvml','sul_amul@yahoo.co.in');>>
>>>> To: Jude DaShiell <jdashiel@panix.com
>>>> <javascript:_e(%7B%7D,'cvml','jdashiel@panix.com');>>,
>>>>     "pgsql-novice@postgresql.org
>>>> <javascript:_e(%7B%7D,'cvml','pgsql-novice@postgresql.org');>" <
>>>> pgsql-novice@postgresql.org
>>>> <javascript:_e(%7B%7D,'cvml','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
>>>>
>>>>
>>> --
>>>
>>>
>>>
>>> --
>>> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org
>>> <javascript:_e(%7B%7D,'cvml','pgsql-novice@postgresql.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
>

--