Hi Serge,
A million apologies for the delayed acknowledgement of your email. The Yahoo
webmail is doing weird things with conversations (your email was hiding in my
sent box instead of inbox, tagged onto the end of my original email !).
But I digress. I will take a look at your suggestions a
Or...
Do you mean to use windowing functions?
http://www.postgresql.org/docs/9.3/static/tutorial-window.html
Or both of course...
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
2014-08-04 19:43 GMT+02:00 Serge Fonville :
> Hi,
>
> Perhaps a CTE would help?
>
Hi,
Perhaps a CTE would help?
WITH NormCTE AS (
SELECT
delta - avg(delta))/stddev(delta) AS deltaNorm
, (echo - avg(echo))/stddev(echo) AS echoNorm
, (foxtrot - avg(foxtrot))/stddev(foxtrot) AS foxtrotNorm
FROM t_subs
)
SELECT
deltaNorm + echoNorm + foxtrotNorm AS
