Skip site navigation (1) Skip section navigation (2)

Re: Initialize the User-defined Aggregate in ECPG

From: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
To: Chengjie Qin <cqin3(at)ucmerced(dot)edu>
Cc: pgsql-in-general(at)postgresql(dot)org
Subject: Re: Initialize the User-defined Aggregate in ECPG
Date: 2012-03-20 08:13:51
Message-ID: CABOikdNUKginZcbgbMuoWjVYbAvHOBRw-Z+B7QPNDXTDpqvgHg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-in-general
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

In response to

pgsql-in-general by date

Next:From: ANTONIETTI Nicolo' (Consultant) (FIAT POWERTRAIN TECHNOLOGIES)Date: 2012-07-11 10:17:25
Subject: Syntax error at or near "psql"
Previous:From: Ashutosh BapatDate: 2012-03-20 04:06:13
Subject: Re: Initialize the User-defined Aggregate in ECPG

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group