CREATE AGGREGATE state function with one argument

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: CREATE AGGREGATE state function with one argument
Date: 2001-06-18 16:02:33
Message-ID: Pine.LNX.4.21.0106181158250.19889-100000@aluminum.cs.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In the manual fro creating aggregate functions (http://www.postgresql.org/idocs/index.php?sql-createaggregate.html) it reads:

sfunc

The name of the state transition function to be called for each input data value. This is normally a function of two arguments, the first being of type state_type and the second of type input_data_type. --->Alternatively, for an aggregate that does not examine its input values, the function takes just one argument of type state_type<---. In either case the function must return a value of type state_type. This function takes the current state value and the current input data item, and returns the next state value.

So I try this:

thalis=# CREATE FUNCTION state_func(int4) RETURNS int4 AS 'SELECT $1;' LANGUAGE 'sql';
CREATE
thalis=# CREATE AGGREGATE myaggr (basetype=int4,sfunc=state_func,stype=int4);
ERROR: AggregateCreate: function 'state_func(int4, int4)' does not exist

I understand that I can have a state function that takes just one argument. Missing smthng?

TIA,
thalis

ps running 7.1.1

Responses

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2001-06-18 16:10:35 Re: OT: Apache::Session::DBI vs postgresql? --help
Previous Message Peter Eisentraut 2001-06-18 15:51:51 Re: primary/secondary index, difference