| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: CREATE AGGREGATE state function with one argument |
| Date: | 2001-06-18 16:39:27 |
| Message-ID: | 2301.992882367@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> writes:
> In the manual fro creating aggregate functions (http://www.postgresql.org/idocs/index.php?sql-createaggregate.html) it reads:
> --->Alternatively, for an aggregate that does not examine its input
> values, the function takes just one argument of type
> state_type<---.
Yup. It also says
input_data_type
The input data type on which this aggregate function operates. This
can be specified as ANY for an aggregate that
does not examine its input values (an example is count(*)).
Perhaps "can" is the wrong word there, you *must* say ANY if your
aggregate is input-value-independent.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis | 2001-06-18 17:29:08 | Re: LARGE table won't use index? |
| Previous Message | Alex Pilosov | 2001-06-18 16:38:11 | Re: OT: Apache::Session::DBI vs postgresql? --help |