Re: what's wrong with this code?

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(at)gmail(dot)com>
> To: Michael Wood <esiotrot(at)gmail(dot)com>
> Cc: Jude DaShiell <jdashiel(at)panix(dot)com>,
> PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>,
> amul sul <sul_amul(at)yahoo(dot)co(dot)in>
> Subject: Re: [NOVICE] 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
>

--