naming arguments in aggregate function

From: Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: naming arguments in aggregate function
Date: 2010-09-05 23:38:24
Message-ID: AANLkTinUdgjuiAWj5EiaiW-1sdzjg2J8cEMFGLs8WVRX@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
I am trying to name arguments in aggregate function, but i don't know how,
so im asking if someone can help me to solve this.
Im working with 8.3.11 version of postgre, and the aggregate function is
this:
CREATE AGGREGATE "grafika"."agg_pov_sphere" (numeric, numeric, numeric,
numeric, varchar) (
SFUNC = "grafika"."_tran_pov_sphere",
STYPE = "varchar",
INITCOND = ''
);

when i change the header to this CREATE AGGREGATE "grafika"."agg_pov_sphere"
(x numeric, y numeric, z numeric, rad numeric, pigment varchar) (
i get syntax error.

Thanx in advance
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2010-09-06 00:35:31 Re: naming arguments in aggregate function
Previous Message Daniel Sobey 2010-09-03 10:49:46 procedure help between databases