Re: syntax issue with custom aggregator

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lucas F(dot)" <lucasf(at)vagabond-software(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: syntax issue with custom aggregator
Date: 2005-03-25 19:39:11
Message-ID: 11069.1111779551@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Lucas F." <lucasf(at)vagabond-software(dot)com> writes:
> CREATE AGGREGATE "property"."pos_avg" ( BASETYPE = "int2",
> SFUNC = "property"."ag_pos_avg_accum", STYPE = "_int4",
> FINALFUNC = "property"."ag_pos_avg_final", INITCOND = "'{0,0}'");

Too many quotes ... try INITCOND = '{0,0}'

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus Moor 2005-03-25 19:39:41 Re: Referential integrity using constant in foreign key
Previous Message Andrus Moor 2005-03-25 19:23:12 Merging item codes using referential integrity