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> 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>
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
--
--
Sent via pgsql-novice mailing list (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