Re: Initialize the User-defined Aggregate in ECPG

On Tue, Mar 20, 2012 at 12:07 AM, Chengjie Qin <cqin3(at)ucmerced(dot)edu> wrote:

> Hi all,
>
> I'm using the embedded SQL in C to create the User-Defined Aggregate(UDA).
> The command is :
> CREATE AGGREGATE aggname( sfunc=kmeans,
> stype=double precision[],
> finalfunc=kmeansfinal,
> INITCOND='{1,2,3}');
>
> Since I need to do the aggregation in multiple rounds. I need to initialize
> the INITCOND using the execution result of last execution （aggregation.）
> Any one can tell me how can I initialize the INITCOND using host variables
> instead of hard code the INITCOND?
>
>
This list is for PostgreSQL users from India and is not very active. If you
would like to reach out to a wider audience, I will suggest you to post
your queries to pgsql-general(at)postgresql(dot)org(dot)

Thanks,
Pavan