Re: what's wrong with this code?

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
>

--

In response to

Responses

Browse pgsql-novice by date

  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