Re: How to write SQL 92 aggregate function?

Here you go: st_union([st_make_point(1.0,1.0),st_make_point(1.0,2.0)]); or st_union(SELECT VALUE gbu FROM [st_make_point(1.0,1.0),st_ make_point(1.0,2.0)] as gbu); On Fri, Aug 4, 2017 at 3:58 AM, Riyafa Abdul Hameed wrote: > Hi, > > After learning about sql92 and

Re: How to write SQL 92 aggregate function?

Hi Riyafa, >> I think it's because the function has not been implemented as an SQL 92 >> function. I would like to know how to do this? You're right. Please check the code that triggers SQL-92 rewrites here and you need to implement the SQL version for st_union:

Re: How to write SQL 92 aggregate function?

Hi, After learning about sql92 and sql++, I thinks that should be the expected behavior. But I would like to evaluate the same behavior using sql++, can someone help me with a query because I lack full knowledge of sql++. Thanks. Riyafa On 4 August 2017 at 12:10, Riyafa Abdul Hameed

How to write SQL 92 aggregate function?

Dear all, With Preston's help I managed to implement an aggregate function that works on arrays: st_union([st_make_point(1.0,1.0),st_make_point(1.0,2.0)]); But this does not work when used in an sqlpp expression: SELECT st_union(gbu) FROM [st_make_point(1.0,1.0),st_make_point(1.0,2.0)] as gbu;