Re: [GENERAL] How to return a modified array from a user-define function...

2000-08-18 Thread Tom Lane
"D. Jay Newman" <[EMAIL PROTECTED]> writes: > I would like to create a standard deviation function using the basic > SQL statements "CREATE AGGREGATE" and "CREATE FUNCTION" using Postgres 7.0.2. > I can't find a way to return a modified array. It's possible to do this in pltcl but I don't think

[GENERAL] How to return a modified array from a user-define function...

2000-08-18 Thread D. Jay Newman
Hi: I would like to create a standard deviation function using the basic SQL statements "CREATE AGGREGATE" and "CREATE FUNCTION" using Postgres 7.0.2. I can't find a way to return a modified array. I've tried things like: CREATE function x (_float8, float8) RETURNS _float8 AS 'SELECT {$1[1] +