From: | Jude DaShiell <jdashiel(at)panix(dot)com> |
---|---|
To: | amul sul <sul_amul(at)yahoo(dot)co(dot)in>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: what's wrong with this code? |
Date: | 2015-06-18 20:11:26 |
Message-ID: | alpine.NEB.2.11.1506181606200.13829@panix2.panix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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>
> To: Jude DaShiell <jdashiel(at)panix(dot)com>,
> "pgsql-novice(at)postgresql(dot)org" <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
>
--
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Wood | 2015-06-18 22:27:54 | Re: what's wrong with this code? |
Previous Message | Eugene Vilensky | 2015-06-18 13:51:13 | postgresql CentOS 7.1 systemd streaming replica startup |